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? Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/ 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006886 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? Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006887 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? Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006917 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006920 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006922 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006924 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1006928 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 Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1008553 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? Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1008556 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' ? Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1008565 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. Link to comment https://forums.phpfreaks.com/topic/190944-slow-mysql-dump/#findComment-1008580 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.