Renamed my WordPress DB and lost everything

  • I am using MAMP on my Macbook and I renamed my WordPress site’s database. After I renamed it, I went into wp-config.php and made sure to change the name there as well using Aptana. I restarted the Apacche and MySQL server after that and I still cannot login. As a matter of fact, I cannot even access the wp-admin page at all.

    I followed the guidelines online to the “T”, but still no joy.

    Can someone please help me in resolving this issue, please?

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)

  • I renamed my WordPress site’s database

    Why?

    From what to what? Are you certain there are no spaces in the db name and also that you have the proper single quotes in wp-config surrounding that db name. No idea about what Aptana is, but a plain text editor such as Text Wrangler for the Mac doesn’t mess with the quotes, as TextEdit can do.

    Ok. No problem
    Just open your wordpress installation directory, and Edit wp-config.php file and replace Old Database name with your new name.

    Hope this will help

    Dion

    (@diondesigns)

    How did you rename the database? That is not possible through MySQL; programs that have database rename functions will create a new database, copy the contents, and then drop the old database. If there are any memory or filesystem constraints which do not allow this process to complete, you could lose your database.

    Having said this, it is possible to safely rename a database if you have the filesystem privileges to do so. You must stop the MySQL service, rename the directory in the filesystem which contains the database, and then restart MySQL.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Renamed my WordPress DB and lost everything’ is closed to new replies.

Tags