vb.org Archive - how to transfer big database from webhost to dedicated server..

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - how to transfer big database from webhost to dedicated server.. (https://vborg.vbsupport.ru/showthread.php?t=130608)

how to transfer big database from webhost to dedicated server..

my site is www.desibbrg.com i am hosting my site in godady .know i have bought a dedicated server which will be ready in 2 more days...
i am worried about how would i transfer the mysql database to the new server..as godady wont provide us ssh so its difficult for me ...if any one have any good suggestion please help....

thanks in advance:) :)

Save it to local disk via phpmyadmin - or use the vb backup system (or one of the mods here) to save it to a file on the server and then ftp the file. Import it via ssh/mysql commands on your dedicated server.

In one of my moves I was given this code by the host and have been using it pretty much ever since. Not sure how big you are, but give it a shot.

Download your current database as a .sql file and then upload it to the new host.

Make your new database/user/password at your new host.

Copy and paste this code into notepad or something and save it as import.php or whatever you want. Edit it as needed with your username/pass and file paths.Upload that to the server and run it www.yoursite.com/import.php It will take a while, but it should import the .sql into your database.

Code:

<?PHP

    $TheFile = "/home/user/public_html/foldername/filename.sql";

    $User = "mysqluser"; // NOTE: Either use a MySQL user or your CPanel/Netadmin user

    $Password = "mysqlpass";

    $DatabaseName = "mysqldatabase"; // NOTE: The database is prefixed with your CPanel/Netadmin user



    $Results = shell_exec( "mysql -u$User -p$Password -hlocalhost $DatabaseName < $TheFile" );



    echo "Results from MySQL import of $DatabaseName with User $User with file $TheFile:\r\n $Results\r\n";

?>

If hes got a dedicated server, he doesnt need to run a php script to run a shell command ;)

thank u for help brothers ...really appreciated ur replies .

i forgot to mension .. the sql and php versions r diffrents.
and my dedicated server is not on godaddy ..it's on another hosting website .

on godaddy sql and php version is :

MySQL Version: 4.0.27
PHP Version: 4.3.11

on new dedicated server is :

php 4.4.4
sql 4.1.21 standard

i hope my data will be comtable on higher php and sql versions.

iam provided u this info ..just to make sure evry thing will go fine with transfering my site ....and u guys r the best to get advice from.

my Q is : do i still need to go with ur suggestions after i provide u this diffrence in php and sql versions..?

thank u in advance agine and agine.... and sorry for my bad english.

regards

Data exported from mysql 4.0.27 will import into 4.1.21 fine. The php versions won't have any effect on this.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00998 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: