Author Topic: fresh instal with MySQL  (Read 11185 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
fresh instal with MySQL
« on: March 17, 2017, 12:32:07 PM »
Hi,
Iīve installed yesterday a CWP in new server, and found out that Mariadb was installed instead of Mysql, I understand that this is the default now.. but unfortunatelly, I really need to deliver some servers with mysql..and not maria.. is there a way to install CWP with MySQL, can anyone assist?

Thanks.

Offline
*
Re: fresh instal with MySQL
« Reply #1 on: March 17, 2017, 03:23:21 PM »
For those who like me, needed CWP With Mysql and NOT Mariadb, I was able to do it, by using an "old" cwp-latest file that I had from a server Iīve installed 3 weeks ago.. Iīve just copied the file from the "old" server to the new one.. and It worked out.. unfortunatelly I donīt have cwp-latest for a CentOs 7.x  Does anybody?

It would be very appreciated if cwp would offer the option to install Mysql instead of Mariadb in Centos 6.x and Centos 7.x Just like they did for Mariadb before..

could it be possible?

Thanks..

Offline
*****
Re: fresh instal with MySQL
« Reply #2 on: March 17, 2017, 04:02:55 PM »
mariadb have all the feature of mysql what extra you need ?

Offline
*
Re: fresh instal with MySQL
« Reply #3 on: March 17, 2017, 05:04:29 PM »
Hi Sandeep,
You might be right, but some of us would be really thankfull if we had the option to choose between them.. as once happened with Mariadb.. thatīs all

thanks

Offline
*
Re: fresh instal with MySQL
« Reply #4 on: March 17, 2017, 09:18:14 PM »
mariadb have all the feature of mysql what extra you need ?

For me.. with Magento + MariaDB i have a lot of database corrupted.
The site was installed on another server with mysql 5.x and had no problems,
I dont know what happened when I imported here because I made a dump to mysql since phpmyadmin was not working ..
This is why i prefer mysql 5.x instead mariadb for now.

2017-03-17 19:01:36 140099315718176 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-17 19:01:36 140099315718176 [Note] InnoDB: Waiting for purge to start
2017-03-17 19:01:36 140099315718176 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 427068511
2017-03-17 19:01:36 140098563704576 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-17 19:01:36 140099315718176 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-17 19:01:36 140099315718176 [Note] Recovering after a crash using tc.log
2017-03-17 19:01:36 140099315718176 [Note] Starting crash recovery...
2017-03-17 19:01:36 140099315718176 [Note] Crash recovery finished.
2017-03-17 19:01:36 140099315718176 [Note] Server socket created on IP: '::'.
2017-03-17 19:01:36 140099315718176 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-03-17 19:13:32 140099314494208 [ERROR] mysqld: Table './xxxxxxxx/catalogsearch_fulltext' is marked as crashed and should be repaired
2017-03-17 19:13:32 140099314494208 [Warning] Checking table:   './xxxxxxxx/catalogsearch_fulltext'

Offline
**
Re: fresh instal with MySQL
« Reply #5 on: March 18, 2017, 01:29:55 PM »
try to export to phpmyadmin mysql compatible db and import manual.
if u export compatible with one format and after import in same format to phpmyadmin need work fine.