SYSTEM INFORMATION | |
---|---|
Webmin version | 1.984 |
Usermin version | 1.834 |
Virtualmin version | 6.17-3 |
Authentic theme version | 19.84.7 |
Kernel and CPU | Linux 4.19.0-17-cloud-amd64 on x86_64 |
CPU | Intel Core Processor (Haswell, no TSX), 1 cores |
Real memory | 942.69 MiB used / 906.64 MiB cached / 1.9 GiB total |
Virtual memory | 1023.99 MiB used / 1023.99 MiB total |
Local disk space | 16.26 GiB used / 3.39 GiB free / 19.65 GiB total |
Package updates | All installed packages are up to date |
OS type and version: | Debian 10 Buster |
Hi,
I am trying to populate my VPS with existing websites. I have installed the Wordpress script and successfully generated a test site. I tried the export/import functions within Wordpress which worked but the result was less than inspiring! Content was there but no theme. So I am trying to do it manually instead.
I have used ftp to download the existing site (Bluehost) and installed the contents into the new site on my VPS under the /wordpress directory. however, when I try to open a page (domain_name/worpress/index.php or other direct links) it just downloads an empty file to my computer. Clearly, the content is not there as it is all in the database structure.
So I see that a Mariadb database has been generated and linked to my new site and I assume all I need to do is populate it with the existing database content and all should work.
So I have exported the database (which is an SQL database) using phpmyadmin on Bluehost and it now sits on my computer. I just cannot find out how to import it to either my server (for subsequent manipulation into place) or into the Wordpress site.
I looked into installing the myphpadmin script but it tells me I do not have any SQL databases so it will not do it. So presumably I have to convert the SQL to a Mariadb format? How? Then upload it to the server? How (ftp) and where? Then I assume I will be able to import it into the site as it will be listed as an importable database? Or are there any further steps?
Appreciate some guidance please. I have several to do!
Geoff