CodingForums.com - View Single Post

Old Pedant · 12-11-2012, 02:22 AM

Use a different database, then.

I do that.

I have a database named "backups".

And when I need to I do something simllar to this:

Code:

CREATE TABLE backups.accounts_20121210 LIKE accounts;

INSERT INTO backups.accounts_20121210 SELECT * FROM accounts;

And, yes, you could have databases named "accounts_backup", "products_backup", etc., if you wanted.

12-11-2012, 02:22 AM	PM User \| #4
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,187 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	Use a different database, then. I do that. I have a database named "backups". And when I need to I do something simllar to this: Code: CREATE TABLE backups.accounts_20121210 LIKE accounts; INSERT INTO backups.accounts_20121210 SELECT * FROM accounts; And, yes, you could have databases named "accounts_backup", "products_backup", etc., if you wanted. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is. Last edited by Old Pedant; 12-11-2012 at 02:24 AM..