Is there a way to convert database to utf8 by command line?

ℹ️ Support
1

Hi,

Is there a way to convert database to utf8 by command line?
When I try to do it through the phplist login, it does not get completed and the database is not coverted.

Any way to do the conversion using command line?

2

@pvanthony It appears that you can run the page converttoutf8 from the command line, similar to processqueue etc.

3

@duncanc Thank you for replying.
I hope you can help me with the syntax for the command line or a link to the documentation.

4

There is a link to the manual on the home page https://www.phplist.org/

Why do you need to convert the database? That should be needed only when upgrading from phplist 2.x. Is that what you are doing?

5

I am doing it because phplists states that after I upgraded it.
I will checkout the documentation.

6

Hi,
From what version did you upgrade?

7

Initially from phplist version 2 to phplist 3 sometime ago. Then to phplist 3.4 a few days ago.
phplist is asking us to do the conversion.

I have checked the documentation but I could not find the command line for converting the database to utf8.

Any advice?

8

You can read more about converting the database on this page:

https://www.a2hosting.com/kb/developer-corner/mysql/convert-mysql-database-utf-8

9

Use the same command as for processqueue but specify the converttoutf8 page instead. So something like this but you will need to know the correct command to run php itself.

php /path/to/phplist/admin/index.php -p converttoutf8 -c /path/to/config.php

But if you know that the tables are already utf8, which you can check with phpmyadmin or similar, then you can probably ignore the phplist prompt.

10

This did it. Yahoooooo! Thank you very much for helping.
On the command line, it says that it has finished with the conversion.

FYI. phplist still shows that it needs to be converted. Strange.

The main thing is that the command line says all done. Great.

Thank you again for helping.

11

Can you show a screenshot of this because it doesn’t sound correct.

12

Screenshot%20from%202019-11-27%2000-13-48
Screenshot from 2019-11-27 00-13-48.png1898×821 45.9 KB

13

Thanks. It seems that warning about the available disk space is displayed even when the database is already UTF8. That looks to be an error in the code for the converttoutf8 page.