[CLUE-Tech] Creating a database with phpmyadmin?

[Grep Ergo Sum - I grep therefore I am]

Ed,

   The output of mysqldump is just a big text file containing a bunch of
mysql commands.

   To restore it, you would normally do something like:

mysql -udbadmin -pdbadminpassword TheDatabaseName < file-created-with-mysqlbackup

If it says "database does not exist", get into mysql, create the database, then
do the above command.

                                        Dave

On Mon, 24 Nov 2003, Young, Ed wrote:

> 
> I want to move a mysql database from one machine to another. I managed to
> dump the database to a file using mysqldump and now want to recreate the
> database on another machine. 
> 
> I'm not sure how to do this so any and all suggestions are welcome. 
> 
> Can I use phpmyadmin to create/populate it?
> 
> I'm running a debian box with a mix of stable and testing. 
> _______________________________________________
> CLUE-Tech mailing list
> Post messages to: CLUE-Tech at clue.denver.co.us
> Unsubscribe or manage your options: http://clue.denver.co.us/mailman/listinfo/clue-tech
> 

-- 
____________________________________________
Dave Hagerty
... and they that weave networks, shall be confounded.
Isaiah 19:9 (KJV)

"On the side of the software box, in the 'System Requirements' section, it
said 'Requires Windows 98 or better'. So I installed Linux."

"There is no limit to the good you can do if you don't care who gets the
credit." - George C. Marshall