![]() ![]() MariaDB > select * from wp_options where option_name like "%home%" | autoload | varchar(20) | NO | | yes | | | option_value | longtext | NO | | NULL | | | option_name | varchar(64) | NO | UNI | | | | option_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | Field | Type | Null | Key | Default | Extra | Then import the databases with the command mysql use wp1 If you had customized your MySQL configuration, you can copy the settings from the my.cnf file located in your backup directory to the new /etc/my.cnf file. MariaDB > SHOW VARIABLES LIKE "%version%" Type 'c' to clear the current input statement. Server version: 5.5.37-MariaDB MariaDB ServerĬopyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Start the MariaDB service and verify its version: /etc/init.d/mysql start It will install the MariaDB-common and MariaDB-compat dependencies and the MariaDB server and client applications. Yum will retrieve and import the GPG key during the installation procedure. Yum install MariaDB-server MariaDB-client # MariaDB 5.5 CentOS repository list - created 14:13 UTCīecause the URL of the GPG key used to verify the integrity of the package downloaded from the repository is included in the above file, you can immediately proceed with the MariaDB installation: Linux rver 2.6.32-358.23.2.el6.i686 #1 SMP Wed Oct 16 17:21: i686 i686 i386 GNU/Linuxīased on the information those commands report, generate the correct MariaDB repository file and store it under the /etc// folder: ]# cat MariaDB.repo Verify your distribution and kernel versions: Uninstall the MySQL server and client, the libraries, and the development tools by executing the command yum remove mysql mysql-server mysql-devel mysql-libs. Start by getting a list of the installed MySQL packages: rpm -qa | grep mysql Next, remove the MySQL service from your server. Include the -user=root -password parameters after the mysqldump command if you have set a password for your MySQL server root user. The location of the MySQL database data folder and the configuration file are similar on most Linux distributions, which means you ought to be able to use the following commands to copy data to your backup location: cp /var/lib/mysql/ backup/ -rĪlternatively, you can create a complete backup of all the databases with the command mysqldump -all-databases > allDBbackup.sql. Make sure you have backups of your databases before proceeding with any database service migration or upgrade. You should see the confirmation Stopping mysqld. Stop the MySQL service with the command /etc/init.d/mysqld stop. To run your existing WordPress scripts with the new RDBMS, start by migrating your existing MySQL database system to MariaDB.įirst, establish an SSH connection to your server. WordPress was developed with MySQL as a back end, but because MariaDB is designed as a binary drop-in replacement of the original MySQL, you can replace MySQL with MariaDB for your WordPress installation and take advantage of its better performance, along with new features such as the two new database engines: XtraDB, which replaces InnoDB, and Aria, a crash-safe alternative for MyISAM. WordPress has evolved from a specialized blogging platform into today’s most widely used open source content management software (CMS), with thousands of third-party themes and plugins. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |