• Creating New MySQL Database & Importing Your Old One Using PhpMyAdmin

    by  • July 6, 2013 • wordpress • 1 Comment

    If you’re migrating a site to a VPS, your first steps are to backup your database and then create a new account for that site in your WebHost Manager. This tutorial constitutes the 3rd step in the migration process.

    Log Into The New Site’s CPanel

    Once your account is fully migrated, you’ll be able to access CPanel by going to yourdomain.com/cpanel. Until then, visit the following address to access it:

    https://YourVPSRootAddress:2083

    cpanel-login-whm-address1

    To log in, you’ll use the credentials setup during the new account creation process.

    Create a new MySQL Database

    You’ll need a new database and a new username, and then you’ll add that username to the database, giving it FULL POWERS. See below:

    mysql-add-user-privileges1

    Log Into your PhpMyAdmin

    Once your new database is created, you’ll find it in the left-nav of your PhpMyAdmin. Click on it to begin the import process.

    new-acct-import-phpmyadmin2a

    Find the .sql backup file you saved during the 1st step and make sure its filesize is not larger than the maximum allowed by your server. The defaul import settings will work for 90% of these cases:

    Allow partial import

    SQL format

    SQL compatibility mode – NONE

    Do not use AUTO_INCREMENT for zero values

    Once your Database is successfully imported, you’ll be able to see all of its tables. PhpMyAdmin will let you know how many tables were uploaded and if there were any errors.

    One Response to Creating New MySQL Database & Importing Your Old One Using PhpMyAdmin

    1. Pingback: Migrate Your Wordpress Website In 6 Steps Using PHPMyAdmin | LeoSaraceni.Net

    Leave a Reply