wmguk Posted February 4, 2010 Share Posted February 4, 2010 Hi, I am trying to move servers, I have a Vbulletin site with over 10,000 clients, and several hundred thousand posts - I've logged in and dumped my SQL from the old server (511MB) but it times out uploading the dump to my new server... is there a better way to do this? Quote Link to comment Share on other sites More sharing options...
JAY6390 Posted February 4, 2010 Share Posted February 4, 2010 I prefer using navicat and transferring this data in real time. It's not going to time out although it is far slower than a dump Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 4, 2010 Share Posted February 4, 2010 is there a better way to do this? FTP the dump to the server and load it locally? Quote Link to comment Share on other sites More sharing options...
wmguk Posted February 4, 2010 Author Share Posted February 4, 2010 Hey, Would you point me in the right direction to do this? I can ftp it up, but how do I load it directly? is there a better way to do this? FTP the dump to the server and load it locally? Quote Link to comment Share on other sites More sharing options...
JAY6390 Posted February 4, 2010 Share Posted February 4, 2010 It will depend on your server and accessibility. Do you have SSH access? If you have a shared server I would suggest you contact your host to ask them to do this correctly Quote Link to comment Share on other sites More sharing options...
wmguk Posted February 4, 2010 Author Share Posted February 4, 2010 It will depend on your server and accessibility. Do you have SSH access? If you have a shared server I would suggest you contact your host to ask them to do this correctly I do have SSH - its a VPS but its not monitored so I dont have a support package Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 4, 2010 Share Posted February 4, 2010 I assume you know how to transfer file to your server. To load sql into mysql database run this from shell prompt mysql databaseName < path/to/dump/mysqlDumpFile.sql Quote Link to comment Share on other sites More sharing options...
wmguk Posted February 4, 2010 Author Share Posted February 4, 2010 I assume you know how to transfer file to your server. To load sql into mysql database run this from shell prompt mysql databaseName < path/to/dump/mysqlDumpFile.sql Oh excellent, I can just ftp to my webspace then go direct in excellent thank you Quote Link to comment Share on other sites More sharing options...
wmguk Posted February 7, 2010 Author Share Posted February 7, 2010 I just tried this but it tells me access denied for user root, using password NO.... How can i set these? Thanks Quote Link to comment Share on other sites More sharing options...
wmguk Posted February 7, 2010 Author Share Posted February 7, 2010 I'm typing : [root@server ~]# mysql -u, admin -p, XXX carpc_forum < /var/www/vhosts/digital-car.co.uk/httpdocs/dump/dcar_vbulletin.sql But it fails... Any ideas? Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 Why commas after -u and -p? mysql -u admin -p XXX carpc_forum < /var/www/vhosts/digital-car.co.uk/httpdocs/dump/dcar_vbulletin.sql and are you sure your username is 'admin' ? Quote Link to comment Share on other sites More sharing options...
gizmola Posted February 7, 2010 Share Posted February 7, 2010 Ditto what Mchl wrote. Also if you want to actually pass the password on the command line prompt you have to use --password. The -p will interactively prompt you for a password which is actually better, because if anyone on the server runs ps or top, they would see the password in the process list. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.