With phpMyAdmin, just scroll down until you see the dumping section. Select the appropriate information, tick the "save as file" box, then "Go". It'll prompt you to save the file. You just use that file, then, as a query to your next database.
Martin >>> "1LT John W. Holmes" <[EMAIL PROTECTED]> 07/24/02 01:38PM >>> I've never had any luck using PHPMyAdmin for dumping databases. They always time out over the 30 second limit. I know if it was my installation, I could fix it, but these are usually with hosting companies, where that's the only access they provide. It's very much a pain in the butt... ---John Holmes... ----- Original Message ----- From: "Justin French" <[EMAIL PROTECTED]> To: "Peter" <[EMAIL PROTECTED]>; "kip" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 11:29 PM Subject: Re: [PHP] MySQL Backup and Restore > Can highly recommend doing it (and a whole lot more) with phpMyAdmin > (http://phpMyAdmin.net) > > Justin French > > > > > on 24/07/02 1:04 PM, Peter ([EMAIL PROTECTED]) wrote: > > > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
