Web Hosting Talk







View Full Version : help !!


i m gr8
03-13-2003, 05:16 AM
how i should go about uploading a 2.7mb database. If i try with phpmyadmin there is a timeout after 300 seconds

DarktidesNET
03-13-2003, 05:26 AM
Can you upload it to FTP and then login to the machine and use SSH to dump it?

i m gr8
03-13-2003, 05:28 AM
i can ftp as well it and ssh also but tell me the process

DarktidesNET
03-13-2003, 05:34 AM
Well, if memory serves me correctly enter this at ssh:

mysql -u<username> -p<pass> database_name > /home/file.sql

Not sure if that's correct, but I think so... if not, I'm sure someone else can tell you the command.

i m gr8
03-13-2003, 05:34 AM
any here who know the exact command???

Darth
03-13-2003, 05:38 AM
Try it and and see what happens

i m gr8
03-13-2003, 05:50 AM
mysql -u<username> -p<pass> database_name > /home/file.sql


in the above command have i to put the <> around the username and password ??

i m gr8
03-13-2003, 05:56 AM
i tried the command with and without the <>
without it showed me a whole list of commands
with it it is saying me database_name : no such file or directory!

i had put my database name in the place of database_name , so i think there is some mistake in this command

anyone know the right one??

Darth
03-13-2003, 06:15 AM
mysql -u username -p pass database_name.sql > /PATH TO FILE

i m gr8
03-13-2003, 07:36 AM
it isnt working as well :(

if i use the command u give , the whole 2.9 mb file which i have uploaded becomes empty and i have to upload again :(

anyone knows the correct one?

i m gr8
03-13-2003, 07:49 AM
thanks alot people
found out the rite now command
here it is if anyone would need it :
mysql -u username -p databasename < /pathtofile

after u wil enter this command it will ask for the password enter it and then done :)

seg fault
03-13-2003, 09:17 AM
scp!

DarktidesNET
03-13-2003, 09:19 AM
Oops, > < can't get them all ...

Atleast you got it working. :)