Akeeba Backup for Joomla!

Tuesday, 17 December 2013 09:45 CST

user68438

When I restored on another server configuration and server control panel similar. I noticed all the errors of the main menu and the font of the article content.

If I use phpMyAdmin or SSH to backup database, then restore your database not found error.

I use SSH with the following command to restore the database

mysql-u username-p database_name <data.sql

I have attached images backup configuration

Tuesday, 17 December 2013 14:13 CST

dlb

What are you trying to do? You only moved the database from one site to another. That would only work in very limited circumstances.

Dale L. Brackin
Support Specialist

English: native

Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Tuesday, 17 December 2013 20:30 CST

user68438

When my server A is not working. I have restored the database on server B and point the domain to server B

After restore the database on server B, then this error

Tuesday, 17 December 2013 21:53 CST

dlb

What error are you getting in your menu?

Dale L. Brackin
Support Specialist

English: native

Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Tuesday, 17 December 2013 22:08 CST

user68438

Error main menu font and Content articles font

I'm using Arial font
Editor: JCE Editor 2.3.4.4 latest
Collation: utf8_general_ci

I use phpMyAdmin to dump the database and SSH still good

Thursday, 19 December 2013 01:52 CST

nicholas

Sorry, I do not understand what you are saying.

1. When you dump your database with phpMyAdmin:
1.1. Are you able to restore it via SSH or not? Please reply with yes or no.
1.2. If you replied to 1.1 with Yes: do you have the same issue as when restoring a backup made with Akeeba Backup? Please reply with a yes or no.

2. You say you have a font issue. What exactly is this font issue? A different font is used? You can't load the font file from your site (if so, which directory)? Unless we know what the symptoms are we can't be of any help.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 19 December 2013 02:30 CST

user68438

1.1 Yes
1.2 Yes

You watch my image attached here you will understand

Thursday, 19 December 2013 03:12 CST

nicholas

Thank you for the feedback. It is now very obvious to me that the problem is not in the database transfer and it's not a font issue.

The most likely problem is in the database encoding. Please delete your new site's database and create it again. This time make sure the collation is set to "utf8_general_ci". If you are not sure how to do that please contact your host.

After creating a new database with "utf8_general_ci" collation retry restoring your site. It will now display correctly.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 23 December 2013 03:09 CST

user68438

Thank you. I have overcome this error

But I have to delete and reinstall mysql on centos, then create a new database

Monday, 23 December 2013 04:22 CST

nicholas

I think you're about to overdo it. When you have a flat tyre you don't buy a new car, you only have to change the tyre with a new one. Likewise, when a database has the wrong collation you don't have to reinstall the entire database server (MySQL), you only have to create a new database with the correct collation. See the syntax for the MySQL command here: http://dev.mysql.com/doc/refman/5.0/en/create-database.html

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 22 January 2014 18:00 CST

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2014-01-22 18:00 CST

Support