Question from a newbie to mySQL...

I have recently re-installed mySQL server after taken backups through mySQLMan. The question I have is how to restore this data using mySQLMan.

I can't see a way to do this via the program, so if not possible, perhaps some guidance on how to restore via the mySQl command line.

Many thanks for any help!


Eraser:
Insight Eye
http://www.insighteye.com/

mysqlimport --help

From mysqlman use the "MySQL Monitor".

You can either select a file from your hard drive or an existing file on your server to restore the data from.

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Thanks a lot Paul for the helpful info.

I just order a mySQL book from Amazon as I need to learn a lot more about this system for future projects, so hopefully this is my first and only post about mySQL

Eraser:
Insight Eye
http://www.insighteye.com/

http://www.mysql.com

has TONS of helpful hints, documents, and code snippets that will help you!

Regards,

Eliot Lee

Yep, but you cant beat a good book for offline reference (mysql: Paul DuBois).

http://www.mysql.com/...mentation/books.html

Cheers.


Eraser:
Insight Eye
http://www.insighteye.com/

This is what I do...

From root:

TO DUMP
mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.txt

TO RESTORE:
mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt

Hope that helps

TO RESTORE:
mysqlimport -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt

...can be used also.

mysqlimport --help
mysqldump --help


Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/