topic mysql backup!! in Operating System - Linux

mysql backup!!

ajay_34 — Sun, 09 Jan 2005 22:47:32 GMT

hi all,
1.i have 3 years(2002,2003,2004) data hosted in mysql database server.i want to backup one year records(whole 2003 records).please give me any idea for this.
2.usually i take backup using mysqldump command.6 months back i backed up all the data from database and deleted all the records. so i want to add old data(6months back data) to my existing database. but i am getting some errors like table allready exist.
any idea?

thanks in advance.

ajay

Re: mysql backup!!

Nguyen Anh Tien — Mon, 10 Jan 2005 01:25:31 GMT

I recommend you using phpmyadmin.
Link to :
http://www.phpmyadmin.net/home_page/index.php.

Re: mysql backup!!

NiCK_76 — Mon, 10 Jan 2005 03:52:34 GMT

Hi ajay,
My suggestion that move whole 2003 records to another table.

INSERT INTO newtable SELECT * FROM oldtable where year = '2003';
delete from oldtable where year= '2003'

NiCK

Re: mysql backup!!

Jan Sladky — Mon, 10 Jan 2005 10:18:51 GMT

tricky question without knowledge of your db,

but generaly you should be able to do select all 2003 data and redirect to the file. Than you can modified this file to the real backup file (insterting insert into table blabla...)

second way is move 2003 data to the separate table in new db and do mysqldump of this db

If I good remember, before restoring of mysqldump file you must remove the tables. If you have a look inside the file , you are gonna see that the tables will be created again.

rgds Jan

Re: mysql backup!!

ajay_34 — Thu, 13 Jan 2005 21:30:11 GMT

hi ,
Tien its really a good tool to mysql administration.thanks for your suggestion.but i am worrying about the security.is there any way for password protuction to phpmyadmin tool?

nick , sladky thank you very much for your suggestion. now i got solution to my problem.thank you very much.

regards,
ajay.