Import WordPress database using Virtualmin

Help! (Home for newbies)
2

Hi,

After successful installation of Virtualmin with virtualmin-install.sh script and going through the post-install wizard, do the following:

  1. Create new virtual server with the domain name used to host your WordPress site and make sure that it’s working (can be resolved (DNS working), can request SSL certificate and etc.)
  2. Go to Install Scripts page and install new WordPress for this newly created domain
  3. Go to File Manager and upload files from your previous WordPress installation under virtual server public_html directory, overwriting WordPress files that were just installed
  4. Go to Edit Databases page, choose the database for WordPress (named usually as yourdomain_wordpress), click manage and on the opened page click Execute SQL, where you can run SQL from file using an upload of your existing dump for your WordPress website.

That’s all.

Perhaps you would also need to manually adjust few option on wp_options table (for example, if domain name was changed) and adjust database settings in wp-config.php file (or simply not overwrite it on described above stage #3).

3 Likes