Atomicorp

Posted: **Wed Dec 18, 2013 6:40 am**

Hello there,

I am new to this forum so please I am trying to import a WordPress database dump into a new database as a client is migrating their domain to us. I have the database dump vkjekule_srfc.sql.gz and I have created a new database for it to import into and have the following details from the wp-config.php file:

/** The name of the database for WordPress */
define('DB_NAME', 'vkjekule_srfc');

/** MySQL database username */
define('DB_USER', 'vkjekule_wp');

But I am not sure how to import this into the database that I created on our server:
salisburyrfc_wp
DB user = salrfc

Please could someone help me with the command that I need to import the database across. I think that is all the details but if you require anymore then I will provide these for you.

Many thanks,
David

Posted: **Wed Dec 18, 2013 7:05 am**

You can do it from the shell:

Code: Select all

# First extract the gzipped file
gunzip vkjekule_srfc.sql.gz

# Then import the SQL dumpfile into your database 'salisburyrfc_wp'
mysql --user=salrfc --password=S4lrfc salisburyrfc_wp < vkjekule_srfc.sql

If you are not comfortable with the command-line interface you can use the import database functionality of a GUI client or web interface such as phpMyAdmin that is usually provided with your control panel.

Tip: never post passwords publicly.

Posted: **Wed Dec 18, 2013 11:01 am**

Thank you for this Prupert, will have a go now! Sorry they are only fake user names and passwords but I just named them so that everyone could understand the scenario and then I can replace them with the real details when the importing occurs, but thank you for the advice.

Posted: **Wed Dec 18, 2013 11:47 am**

Ok I am still a bit confused.

1. Do I have to be in a certain directory to run this command?

2. I am logged into SSH as root and need to run this command: mysql –u myuser -pmypassword salisburyrfc_wp < filename.sql but the file is root/myname/myfile.sql so do I have to do a path to the file before the filename.sql section of the command?

Many thanks,
David

Posted: **Wed Dec 18, 2013 12:38 pm**

I think I have worked out how to execute the command. Now I have run it I am getting the following error:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' at line 1

So I tried importing without the first line but that still gave me another error. I am sure I just need to take a step back and relax and then look at this again from another angle. But please if anyone can help then that would be much appreciated.

Many thanks,
David

Atomicorp

Importing a .sql.gz database into a new database

Importing a .sql.gz database into a new database

Re: Importing a .sql.gz database into a new database

Re: Importing a .sql.gz database into a new database

Re: Importing a .sql.gz database into a new database

Re: Importing a .sql.gz database into a new database