Backup MSQL errors

[gcampos]

Getting the following when trying to back up the db with Backup MYSQL mod:

 Result code: 2
Warning 0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Warning 1 => /usr/bin/mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
Warning 2 => /usr/bin/mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect
Error Failure: The database has NOT been saved.

Anyone know what the reason?

thanks,

Gerry

ZC137

[DrByte]

Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect

This suggests that the mysql client software on the server doesn't match the mysqldump version or else it doesn't match the security model requirements configured by the mysql server.

Basically, you need to report the errors to your hosting company for them to resolve.

[DrByte]

Warning 0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Warning 1 => /usr/bin/mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file

These say that the mysql client isn't configured properly. Again, this is an issue for your hosting company to resolve.

[gcampos]

Dr Byte,

Thanks will check it out with them.

Gerry

[countrycharm]

I have a question for you DrByte. I hope I'm not off course here. When I go to phpMYADMIN database and back it up. No problem there. But if I ever need to go to import the data, It tells me that the (text file size can not exceed (Max: 2,048KiB) How do I fix this to be able to except a bigger KB text file. My store is way bigger that that. Thank you

[DrByte]

When I go to phpMYADMIN database and back it up. No problem there. But if I ever need to go to import the data, It tells me that the (text file size can not exceed (Max: 2,048KiB) How do I fix this to be able to except a bigger KB text file. My store is way bigger that that. Thank you

You'll have to talk to your hosting company to get them to change the maximum size allowed for upload.
In PHP scripts that's usually a combination of post_max_size and upload_max_filesize settings.

[countrycharm]

Thanks DrByte I'm contacting them now. I hope they will do what they are suppose to do. Thank you again

[countrycharm]

Hi DrByte this is what my sever houser said

Our support staff has responded to your request, details of which are described below:

Discussion Notes
Support Staff Response

Thank you for contacting Online Support. There is a 2MB limitation imposed on the importation of databases into the shared hosting servers; you would need to either break up the file into pieces that will fit under this limit, or FTP the database file into your hosting space and have us install it for you. We apologize for any inconvenience this limitation may cause. Please let us know if we can help you in any other way.

Sincerely,

Eric B.
Online Support Technician

How would I break this file into smaller pieces to work.

[DrByte]

How would I break this file into smaller pieces to work.

There will be a number of CREATE and INSERT statements in the file.
Break the file up into several, being sure only to break before a CREATE or INSERT statement.
Then import the files one by one.

[countrycharm]

Hi DrByte, Thanks for your speedy reply. Not sure exactly what your saying to do. Couldn't I just download half of my database in a text file and then do the same with the other half. If I ever have to import it I could import the first half then the second part of it, would that work or not. Thank you again