Help needed to move MySQL database

Customer Support Customer Only Discussion
1

I’m trying to move a MySQL DB from server x to server Y

I exported the DB on server x, but on importing to server Y get this error

MySQL said: Documentation
#1044 - Access denied for user ‘aaa_bbb’@‘localhost’ to database ‘ccc_ddd’

So, what do I need to do???

Thanks,
Rob

2

Just found this from a search of the forum - by Stephen way back

of course I forgot one thing, take MySQL SQL Export, then import on new side but strip off the use db_name from the top of the SQL export, so that it will import over to the new without any error it can easily be done in notepad.

Seems to have worked…

3

Yep stripping off the ‘use DBname’ is important and key thing I should remember every time :slight_smile:

4

Moved a small DB with no problems. But, the next DB to move is large, and the import into MySQL10 is limited to (Max: 2,048 KiB) Even if I zip up the DB I want to move it is still too big.

I’ve raised a ticket asking for advice [RS #CJK-53202-210] but would appreciate any pearls of wisdom.

Thanks
Rob

5

SQLyog community edition can do much larger, I have done 28MB export/import via it before :slight_smile:

In fact I have done 2330MB DB via it before as well, but not using a net connection on dsl/cable, but from a server to mysql server, worked well.

6

Well, success - all seem fine and dandy. This is what I did

  1. Create new DB on MySQL_NEW
  2. Export old DB from MySQL_OLD to your computer
  3. Download config.php from web server
  4. Edit this config.php with new DB name, user and p/w
  5. Import old DB from computer to MySQL_NEW (using either phpMyAdmin or HeidiSQL)
  6. Rename config.php on web server to config_OLD.php (as a safety measure)
  7. Upload edited config.php to web server

That’s it - should all be fine.

Thanks to Shubham Saxena from the Helpdesk for suggesting HeidiSQL which can handle DBs larger than 2MB

Oddly, didn’t have to apply Stephens tip re stripping out old DB name for 9 out of the 10 DBs I moved.

7

hm. how did you get HeidiSQL to log in? I am trying to access a db on mysql8 as well. I put in the IP 173.x.129.x
user acct_dbadmin
pw mypassword
port 3306
Databases acct_mydbname

tried playing with a bunch of stuff. I always get the error:

SQL Error (1045): Access denied for user
‘acct_dbadmin’@‘xx.xx.xx.xx[my home IP address]’ (using password: YES)

To me the single quotes look odd, as if heidi should be sending
“[email protected]”
but instead it is sending wrong spacing or oddly quoted stuff?

8

I didn’t use an IP address for the server, but used mysqlX.m****here.biz

Then just used my usual credentials to login.

Hope this helps. If you get really stuck ask Stephen as he is a real guru.

9

I didn’t use an IP address for the server, but used mysqlX.m****here.biz

Then just used my usual credentials to login.

Hope this helps. If you get really stuck ask Stephen as he is a real guru.