[CLUE-Tech] Creating a database with phpmyadmin?

[Randy Arabie]

Quoting "Young, Ed" <Ed.Young at echostar.com>:

> 
> 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. 

How did you dump the database?

If you used the mysqldump command, you should be able to use the output file 
generated by that command to create your new database *and* populate the tables.

This dumps the database structure and data into a file, dump.sql:

   shell> mysqldump –-user admin –-password=password mydatabase > dump.sql

It takes two commands to load this into a new database.  At the mysql command 
prompt, you need to create your new database:

   mysql> create database newdatabase;

Then load the tables and data (from the shell prompt):

   shell> mysql -u USERNAME -p newdatabase < dump.sql 

Here's a link to the manual:

http://www.mysql.com/doc/en/mysqldump.html

> I'm not sure how to do this so any and all suggestions are welcome. 
> 
> Can I use phpmyadmin to create/populate it?

Sorry, I'm not familiar with phpmyadmin, but I'm sure there's a way.

> 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
> 


-- 
Allons Rouler!

Randy
http://www.arabie.org/