Since you have already dumped the structure and data to a file all you need to do is paste the contents of that file to mysql. You could also use phpMyAdmin (since you mentioned using it) to load the entire text file - look under the 'SQL' tab (in more recent versions).
Quoting [EMAIL PROTECTED]: > I need to copy a database and all its tables and contents to a backup > server. The server > they live on is on an ISP, the server I want to back the up on is in my > office in another town. > I can access the ISP's server via phpMyAdmin and dump the data to a .sql > file, but then > what do I do to recreate the database and all the tables on my local mysql > server? What > do I look for in the manual? > > -- > Chip > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
