Transfer database from server to my PC

Anon

Hi!
Anyone knows how can I transfer one database from my server (linux) to my Win98 PC ?
I have already installed Apache+PHP+MySQL on PC, I also use mysqldump to backup the database, but when I try to import it use mysqlimport , I failed.
Do I have to do anything before I can import a database ?

Anon

what kind of error did you have when using the mysqlimport?

You can get more inform form the mysql.com, or you can first try to use mysqldump to get the database datas, and then use the
mysql -p[password] [DB] < xxx.sql.

Hope that helps.

Anon

why not use phpMyAdmin .. its nice frontend database admin..

get it free from phpwizard.com and of course its browser based, so its hassle free. it does gives you to dump the database, and copies it straight to your PC, from the server.

Anon

Yes, I tried it all night, but :
1. I was not able to use "View dump (schema) of table" and save as a .sql file to dump and import, when i try import from my PC's myphpadmin, it shows syntax error when importing data.

When i use csv format to dump and import, everytime I try, it grab the data but add a lot of empty records, I don't know why.

3.What I have in my table are HTML tags, so maybe some tags effect the importing process ?
Cause I try use another table to test drive this dump/import thing, it works.

Anon

What kinds of computers are you using?

Certain version of MySQL build different forms of tables on different machine architectures.

My ears perked up when you said some records were empty because that's what I had when I tried to bring data from my PowerPC G3 chip PowerBook (running LinuxPPC) to my Intel P-II Linux box.

I have a vague memory of the problem being something to do with myisam (sp?) table formation or something like that.

There ought to be a way, however, to suck your data down to a lump of insert statements and insert them all on the other box.

Let me know if you find a fix!
-john