CODEWITHSUNDEEP
phpmysqlmariadbjoomla3.0
Sonnenbiene
Sonnenbiene

Reputation: 38

How to move Joomla mySQL DB to Maria DB

My web provider just informed me that they will dump MySQL and will replace that with MariaDB (due to the reason that they will soon move over to Debian9 and Debian 9 will no longer include MySQL and will include MariaSQL (see here). They said they will move over my files, however I need to move my DB content from server1 to server2 manually as I need to adjust the joomla configuration.php to fit that.

I learned now that there should be no real difference in using MySQL or MariaDB so I think its fine to move my content. However I have issues to do that. I know I must adjust my configuration.php to point to the new server, however I do not know how I can export my the MySQL joomla content and import that in Maria DB. In the very past I used a cgi-script to dump the SQL content to a file and then use another cgi-script to upload that to a new DB. However that's 10 years ago and I´m not sure if that would be still the best option here.

thanks

Upvotes: 1

Views: 1102

Answers (1)

Tuncay Göncüoğlu
Tuncay Göncüoğlu

Reputation: 1767

this generally depends on your hosting configuration, mainly on where they allow access to your database from, but normally, it is as easy as an export and an import like:

mysqldump olddatabasename -h oldhostname -u oldusername -p > mysqldata.sql

and then

mysql -D newdatabasename -h newhostname -u newusername -p < mysqldata.sql

Obviously you will need to adjust your PHP settings to point to new host.

Upvotes: 1

Related Questions