Category MySQL

mbstring PHP extension was not found

I was getting an error message when I accessed phpMyAdmin. The error was:

"The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

This error means that mbstring PHP extension is not enabled or installed. In my case it was not enabled.

To resolve this I had to enable it in my ...

Read More

Automatically backup MySQL database

I needed to backup a couple of MySQL databaes automatically. Here is what I did to accomplish this.

I created a folder called mysqlbackup. I then created a script called “” and put this script file in the mysqlbackup folder.

It contains “rm /mysqlbackup/DBNAME_backup.sql
mysqldump -u USERNAME -pPASSWORD DBNAME > /mysqlbackup/DBNAME_backup.sql

I used the “rm” command to remove the last database backup before the new ...

Read More

Backup MySQL DB in command line

So you have a website on a dedicated server. You need to backup a database. You tried to backup through PhPMyadmin but it keeps timing out. Here is what you need to do. Backup the database through a terminal session. SSH into your web/MySQL server and run the following commands below.


##Without G Zip Compresssion:

##With G Zip Co...

Read More