lovewht
03-22-2002, 01:06 AM
Hi!
I want to backup mySQL and restore it in other server. How can I do it?
Thanks
I want to backup mySQL and restore it in other server. How can I do it?
Thanks
 | View Full Version : How can Backup mySQL serve-you 03-22-2002, 01:47 AM mysqldump -lv -uroot -ppassword -A > mysqlbackup-`date +%d%b%Y-%H%M`.sql To restore: mysql -uroot -ppassword < mysqlbackup....sql -Dan Lats 03-22-2002, 01:49 AM Or, if that's a little confusing, have a read of this thread: http://www.webhostingtalk.com/showthread.php?s=&threadid=35040 Lats... lovewht 03-22-2002, 08:31 AM Unfortunately, I don't have shell access. Do you know any third party software that could be backup/ restore and/or import/ export other software like MS-Access? 9onlinehost 03-22-2002, 12:47 PM do you have remote acess mysqlfront is a program or phpmyadmin these programs can both do what you are asking http://www.phpwizard.net/projects/phpMyAdmin/ http://anse.de/mysqlfront/ bitserve 03-23-2002, 01:35 AM Originally posted by lovewht Unfortunately, I don't have shell access. Do you know any third party software that could be backup/ restore and/or import/ export other software like MS-Access? You can try running the commands that Dan mentioned in a CGI script. |