[CLUE-Tech] Creating a database with phpmyadmin?

[black at galaxy.silvren.com]

Not sure if you can do that with phpmyadmin, never used it.

This way is probably easier: Just replay your dump back to the mysql
running on the new box.

cat backup.dump | mysql

Beautifully simple.

Then if you have a transaction log (sounds like you don't though) you can
replay everything that happened since the last backup, bringing the
database completely current.

mysqlbinlog host-bin.xxx | mysql --one-database=dbname


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
>