MySQL & Localhost

[Logikos]

Was wondering if anyone knew how to upload a .sql file using your localhost. I tried threw phpmyadmin but even after i up the upload size in the php.ini file. It still dont work. I tried with a 350mb sql file and waited beyound hours and nothing. Then i tried with a 5mb one and still nothing.

Basicly i would like to know if there is a way the SSH? I tried putty but that failed. Any other ideas? Thanks in advance,

[Osterling]

upload it thro FTP

[Logikos]

lol its on my localhost. Nvm i figured it out, used the dos prompt.

[jcr]

I use something else since my host does not allow ssh access, i use a program called mySQL Front, it is very simple to use and can restore / import / export large sql files.

[Logikos]

this is on my localhost. My HardDrive. Computer, PC, Windows. Desktop..... Putty is da bomb :p

[Dean C]

I had this exact same problem. First of all I had to upgrade to the latest version of mysql as a bug was fixed in earlier MySQL4 versions which made this time out.

Move the .sql file into your MySQL/bin folder (wherever you installed MySQL)

Then go to Start > Run > type 'cmd' > press enter

Now i'm going to assume you know your way around DOS and command prompt so navigate to the MySQL/bin directory (wherever you installed MySQL) and then type:


mysql -uroot -p databasenameonlocalhost < filename.sql


It should prompt you for a password. If you have a global mysql password on localhost then enter it. Otherwise just press enter when it asks. It took me about 30mins IIRC to import a 200mb DB :)

Good luck!

[Logikos]

lol its on my localhost. Nvm i figured it out, used the dos prompt.
Thanks dean, but i figured it out.