Loading Mysql database from file

Maybe it's not a proper place to ask this question, but maybe someone
could provide me the way to load file with schema and data of mysql
database (created by phpMyAdmin on Windows system), to create a new
database on linux system.


Greetings,

Konrad

Konrad wrote:
> Maybe it's not a proper place to ask this question, but maybe someone
> could provide me the way to load file with schema and data of mysql
> database (created by phpMyAdmin on Windows system), to create a new
> database on linux system.
If your familiar with phpMyAdmin - then use it!

Otherwise on the command line:
// after decompressing the dumpfile

mysql -p -u username dbname<dumpfile.sql

e&oe!!

Thanks a lot :)

greetings

Konrad