MYSQL problems please help me! somebody!
 

Hi I have a .sql file I need to import into a mysql Db, the problem is I cannot do it thru MYPHPADMIN because the file is too big and my browser locks up.

how can I do this thru ssh??


someone plz :)

I will tell you....




for one million dollars.

if my memory servers me:

mysql -p databasename > datebasenamefile.sql

and you have to create the database first.

I don't have my files at home, but I think that's right.

J

Ok the one million dollar paypal pament you made (after we arranged the details over ICQ) has been recieved.


mysql -uUSERNAME -p newdbname < /path/to/dump.sql


STOP TRYING TO FUCK WITH MY BLING!

EVEN THOUGH YOU ARE WRONG!

Man, I was way off. Must be the blood in my beer system.

It's impossible to do, don't even try it!

Beer makes dumb, eat musroom.

Ok listen up.

First create a new database in MyPHPAdmin.

Then use telnet/ssh and connect to your server (if you don't have access, contact your host and ask them for access).

Upload the .SQL file with FTP/Telnet to the root and then type this in telnet/ssh:

mysql -u username -p newdbname < nameofdb.sql

username = mysql username
newdbname = the name of the db you just created in MyPHPAdmin

And good luck :winkwink:

I had mushrooms on my pizza, but I drank beer....don't those two just cancel each other out?

Worked Beautifully!

THANKS! :)

Np :) I had a shitload of trouble with it before. I know how fucking annoying it is. That's the only reason I'm helping you :winkwink:

If you don't know, you shouldn't answer.

Had that been his only copy of that sql dump, it would have been wiped out.

That dumps the database to a .sql file named databasefilename.sql you need the pipe the other way around.

mysql -p databasename < databasenamefile.sql

Hey guys

im trying to do this again now, and it seems like everything is copying over with no errors..

but when I got to check the database there is no data in it??

has that ever happened to anyone?

bump