How do I upload a 60MB MYSQL db on my server?

[sidyadav]

I have written a few messages about problems installing Apache etc. but now its done on my XP box, and I just gotta restore everything on the MYSQL db, I used a WAMP, And have : PHP, MYSQL, PHPMYADMIN, Apache etc.

But the db size is about 60MB gzipped and about 200MB .sql file (400MB size on disk) I tried restoring it via PhpMyAdmin but it says:
No SQL Query!

Is there any other way to do it?

Thanks,
Sid

[edited by: sidyadav at 5:37 am (utc) on Nov. 17, 2003]

[hanuman]

create a mysql dump and compress it.

if you have SSH, you can copy it through the command line

if it is still to large, maybe send your host the cd and ask them to copy ot to the server. if you are on a good host you would be able to ask for it

[sidyadav]

hanuman, I have already tried the compressing bit and as I said "16MB gzipped".

I don't have a host etc. as I said, I host it, well, not fully host it, but I have everything on my XP box. I've seen people talking about "Doing it Manually" Anyone know how to?

Sid

[moltar]

Here is how you can do it if you are trying to import it onto linux machine:

1) Transfer your gzip file over FTP to your linux machine
2) Go into SSH and login
3) type the following commands:

tar xvzf YOUR_FILE.tar.gz
mysql -uUSERNAME -pPASSWORD DATABASE_NAME < YOUR_FILE/YOUR_FILE.sql

You should replace the capitalized word with your info.

[sun818]

What I do sometimes is to copy sections of the mySQL dump file and paste it into the mySQL> command line. It will load parts of the command a little bit at a time. phpMyAdmin also has a SQL load feature. But I warn you, with either method copying too big of a passage will "freeze" your system up.