[SOLVED] Export mysql database tables

Issue

this is a really basic question, apologies in advance:

I have multiple websites (based on wordpress) sharing the same mysql database named ‘myshareddatabase’.

I want to export the database related to the website named ‘xyz’.

So I select all tables with the prefix wp_xyz. Export.

And I will obtain a file named ‘myshareddatabase.sql’.

Now I have exported the database related to my xyz website. That’s it.
Is that correct? Is there anything else I need to check?

Many thanks

Solution

Now you can import them. Beware using the same prefix $table_prefix = 'wp_xyz'; in your wp_config file and if an error occurs during import from phpMyAdmin try to use the below method:

In MySQL/bin file run this

mysql -u username -p database_name < file.sql

Note: It is better to use the full path of the SQL file file.sql.

Answered By – Nikos Koutelias

Answer Checked By – Willingham (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published.