Second the MySQL Front recommendation. That's one heck of a tool that makes things really easy.
Otherwise, use mysqldump like Peter recommended. To dump the databases, use this from the system prompt: mysqldump -uuser -ppassword database_name > filename.sql To import, create the database and use this: mysql -uuser -ppassword database_name < filename.sql ---John Holmes... > -----Original Message----- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 11:04 PM > To: kip; [EMAIL PROTECTED] > Subject: RE: [PHP] MySQL Backup and Restore > > grab ur self a copy of myphpadmin or use mysqldump or just simply make a > copy of the data dir or grab ur self a copy of mysql_front > > > -----Original Message----- > > From: kip [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, 24 July 2002 12:58 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP] MySQL Backup and Restore > > > > > > Hi, > > > > Can you tell me the steps of backup and restore the databases in Mysql? > > > > And can i specific a path for the backup file? > > > > Futhermore, i have installed the MySQL in Win2000 but i don't know how > to > > restore the database of MySQL from a Linux server to Win2000 MySQL. > > > > Thanks > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
