[New] Restoring a Mysql backup from a web to web (without downloading the backup)

[counter]

[Still in-need to know other methods than the posted below please help]

hello
i recently moved my site to a new server i moved the files but i still got to move the sql databases
i got a mysql backup of my forums posted online at an address similar to mysite.com/backups/mysql.sql

i need a way to restore this backup without downloading it to my pc and reuploading it using phpmyadmin
i need a faster way
btw i got cpanel 10

summary:
i got a mysql backup on my old server and i want to install it on the new one without downlaoding then reuploading


IMPORTANT THING
i got a script that can copy the sql backup file to the new server but i dont know if i copied the db to the new server where to move the backup to file to what directory


Plz guys help me

 

[Alex.]

Go into phpmyadmin, and export the data from a database.
Don't click the save as file button.

On the next page, a big textbox full of sql code should appear.
Go to your new server, open phpmyadmin, create a database, click the SQL tab, and copy the commands from the old server's textbox to the textbox on the new server's phpmyadmin page.
Press the rubmit / run / execute button, and the data should be imported into the new database.

 

[dezinerite]

Worked for me! I'm so glad, heheh...thanks!

 

[counter]

this can work bu the prob is the database is HUGE!
its exeeding the max execution time allowed so i need another way please
[if possible uploading the db as a file to my server and doing a trick to restore the database by coping it to the databases locaton (which i dont know where it is in Cpanel 10)]

please any suggestions

 

[smagik]

read from 1 database -> write the data to the other. A few lines of php code...

 

[counter]

am not a super phper i got slight idea about php

please can u help me in setting that script up

thx

 

[counter]

please any one could help

 

[neroux]

Do you have shell access on your machines? You could do a database export with mysqldump, then upload/download to/from your new machine and restore the database there.

 

[counter]

dont know how shell stuff work i dont think i got it
but i got a normal full backup backup (its 7gb my new server is much smaller i dont want to send all files)
anyways i got the backup on my server how can i install it

 

[ds2007]

you can do it with free mysql tools like SQLyog
link: http://www.webyog.com

just connect to old database and at "DB" menu you can find "Copy database to different Host/DB" to upload your DB

its a very handy tool for mysql db to edit, update, download etc.

hope it helps

 

[counter]

wowow might be helpful
but do u mean tool is :SQLyog MySQL GUI - Community Edition?
is it a script i got to install on my server to use or a website :P

 

[ds2007]

wowow might be helpful
but do u mean tool is :SQLyog MySQL GUI - Community Edition?
is it a script i got to install on my server to use or a website :P

yeah community edition and is a desktop application so you have to download and install in your pc

 

[counter]

thx this is a good program but i faced a problem
i entered the msyql host as ftp.mysite.com
username also entered and password and port as 21 and i tested the connection
it showed this error
i couldnt connect why is that ? this error appeared
Error No. 2013
Lost connection to MySQL server during query


that what i am always getting

 

[ds2007]

thx this is a good program but i faced a problem
i entered the msyql host as ftp.mysite.com
username also entered and password and port as 21 and i tested the connection
it showed this error
i couldnt connect why is that ? this error appeared
Error No. 2013
Lost connection to MySQL server during query


that what i am always getting

mysql host should be IP of your mysql db
username and password should be of mysql db as well not of ftp
for IP if you dont know then you can check it out with your host

 

[counter]

my host will take ages to reply
is there is anyway i can figure it out ?

 

[ds2007]

if you have access to cpanel then go to "MySql"
after clicking mysql under "Access hosts" you can find the IP
remember you also need IP and user name and password of mysql of new server

 

[counter]

sa

wowowowow
1 sec
i changed the port to 3306
i entered my domain name i think its working but an error is saying ACCESS DENIED with error 1045
how isnt the user and pass same as the cpanel user and pass ?

i need to view all db and not one

 

[ds2007]

maybe you have used different username and password for mysql db
you can view users or create new one from where you got the ip