how can I upload a large size DB backup file(20M+)?

P

peterhou

Verified User
Joined
Dec 9, 2004
Messages
26
Hi
I want to turn my old site to new server.and I creat a new user & DB(which is same name as old one).
Now,I select "Upload a Database Backup (.gz)" and select the gz file from my PC which filename is "F:\top100cn_xxx.gz"(the same as download filename).
But when I click "upload" there came up a blank page which say:"Error: document not found".(the blank page's url is"http://210.245.188.17:2222/CMD_DB").Is this mean there is no CMD_DB on this server?
Then how can I upload a large size DB backup file(20M+)?
regards
peter
 
do it in SSH after uploading via ftp


OR use the invision mysql tool (it works on more than just invision) google invision mysql tool
 
The MySQL website has a tool you can install on your desktop to manage MySQL databases on your server.

Jeff
 
jlasman said:
The MySQL website has a tool you can install on your desktop to manage MySQL databases on your server.

Jeff
Click to expand...


ah but wouldnt that depend on you not having the sql port bocked on the server firewall?

which i do have blocked now that you mention this tool though........


is it safe to leave the mysql port open?

i always thought best pratice was to have it firewalled off so that only localhost can communicate with mysql. (assuming mysql is on the same machine as the scripts accessing it)
 
I've never used it to update a database so I have no idea how slow or fast it is.

I have a static IP connection from my home office and I open the firewall specifically for my IP#.

Jeff
 
hmm if he has SSH access maybe upload it via ftp and run the command to inport a db


cant remember what that command is

isnt it mysqladmin or somit simular.
 
upload the database then use this command :

mysql -u[username] -p[password] [databasename < file.sql

you need to yup -uusername and -ppassword no " "
 
so assuming he uploads the file called

top100cn_xxx.gz

woudlnt he


upload file


cd /home/username/directoryname/

tar -zxf top100cn_xxx.gz

then something like

mysql -umyusername -pmypassword mydb < top100cm_xxx.sql

?
 
You must log in or register to reply here.
Back
Top