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
 | View Full Version : help !! 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. :) |