Transferring servers: MySQL database not working, original site is just gone now

  • minisunshine

    (@minisunshine)


    10 years, 3 months ago

    I am so lost. This is my first time venturing into the world of PHP and MySQL.

    I was/am trying to transfer a site from a temp location to a new server and url. I was following a how to that was probably a bit more advanced than I was.

    I should have used this walkthrough from the beginning but I only found it once I started troubleshooting my fist blundered attempt. Though I am not sure it would have made a difference. http://codex.wordpress.org/Moving_WordPress

    What I did:

    Download your entire WordPress installation to your hard drive.
    Download your database.
    Go back to your OLD blog and go to Administration > Settings > General and change the url (both of them) to that of your new site.
    Login on your server and go to phpmyadmin and export file and save your database with new name, upload this new database and the copy of the wordpress core files with the edited wp-config.php to your new server.

    It didn’t work. There was an error with my database backup.

    “Error
    SQL query:

    — phpMyAdmin SQL Dump
    — version 2.6.4-pl3
    — http://www.phpmyadmin.net
    —
    — Host: db506384322.db.1and1.com
    — Generation Time: Jan 06, 2014 at 12:25 AM
    — Server version: 5.1.72
    — PHP Version: 5.3.3-7+squeeze18
    —
    — Database: db506384322
    —
    CREATE DATABASE db506384322 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

    MySQL said: Documentation

    #1044 – Access denied for user ‘dbo509356871’@’%’ to database ‘db506384322’ ”

    So now it doesn’t work and I can’t log back into my old site. Tried some tips I found on here but I think I only made the problem worse because now I can’t even see my old site, just prompts me to start wordpress again. “enter site name” etc.

    Tried to reload my old sql file on my original server and it gives me this error

    SQL query:
    — phpMyAdmin SQL Dump
– version 2.6.4-pl3
– http://www.phpmyadmin.net
– 
– Host: db506384322.db.1and1.com
– Generation Time: Jan 05, 2014 at 10:49 PM
– Server version: 5.1.72
– PHP Version: 5.3.3-7+squeeze18
– 
– Database: db506384322
– 
CREATE DATABASE db506384322 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci
    MySQL said: 
    #1007 – Can’t create database ‘db506384322’; database exists

    any advice would be so very appreciated!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Joms

    (@jomsky)

    10 years, 3 months ago

    It seems like you are trying to create a new database on your SQL backup and your database user does not have the proper permission to do so.

    If this was not your intention (if the database already exists and you only need to import the tables)

    Try removing this part at the beginning of your sql file:

    CREATE DATABASE db506384322 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

    and save your sql file.

    Go to phpmyadmin, click on the database, and import the sql file.

    Thread Starter minisunshine

    (@minisunshine)

    10 years, 3 months ago

    Thank you for your response!

    I tried that and got the response:

    #1044 – Access denied for user ‘dbo509356871’@’%’ to database ‘db506384322’

    I don’t understand why my user wouldn’t have permission? I can’t figure out how to unrestrict the user.

    Thread Starter minisunshine

    (@minisunshine)

    10 years, 3 months ago

    You were right! It work to upload the file on the original server again. I missed something the first time I tried.

    Thank you so much!

    It doesn’t work on the new server though. Does it have something to do with username and database name?

    Thread Starter minisunshine

    (@minisunshine)

    10 years, 3 months ago

    I had to change the database name in the file to the new database user name on the new server. It works now.

    Thanks again!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Transferring servers: MySQL database not working, original site is just gone now’ is closed to new replies.