| Question: |
Hello. Cannot deploy the backup, as in phpmysql is a limit of 50 MB, and my dump files 70 MB. Please expand it in a DB that I created (bismark_carmasters). Dump put it in the root directory on the FTP.Thank you! |
| Answer: |
Hello syntax error in import
ERROR 1064 (42000) at line 1253363: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near `STATS_PERSISTENT=0` at line 11
|
| Question: |
I understand that the problem is that the old host server Version mesql 5.6.30, and you have 5.5. You can do something to update mysql? |
| Answer: |
mysql can not be updated. if you update the version then with high probability many of the sites on the server perstanut to work or will raboatet is incorrect, and is completely eliminated. you can predloziti vps server where you can try install mysql 5.6 http://www.ukrline.com.ua/tarif_vps.php . it is slightly more expensive than the fare you have selected you can also try to redo the dump again and we`ll do the import |
| Answer: |
https://www.quora.com/What-does-error-1064-mean-when-restoring-a-MySQL-dump |
| Question: |
Yeah, but it`s 30GB, and then 100 ). Let`s try. Please change the settings. |
| Answer: |
make a new dump with the parameters of mysqldump --skip-create-options |
| Question: |
Would you like me to help you transfer the database? No backup is done.178.63.92.58 ssh login: rootpass: qazxswedc040385Mysql user: zorinuapass: qazxswedc040385BD name: zorinua_zaebaloЕсть panel: 178.63.92.58:2030login: rootpass: qazxswedc040385 |
| Answer: |
the dump is copied |
| Question: |
OK, thank you! Write out the end of the import. |
| Answer: |
the database is imported into the database bismark_zaebalo |
| Question: |
symbolic name ). Thank you so much! Going to carry on. |
| Answer: |
the name is the same as on Your server zorinua_zaebalo , only changed the user prefix. |
| Question: |
Please add a test domain.P.S. Your tickets see Google. I think they can be fairly confidential information, you may want to close them from the search engines. Here`s an example: http://ukrline.com.ua/sticket.php?do=viewsticket&id=76501&pgn=4 |
| Answer: |
test domain You have bismark.testv1.testforhost.com Google sees no ticket and selected for Google |
| Question: |
Tell me more please: I config site it is necessary to specify sql_socket. Previously on the old hosting was `/var/run/mysqld/mysqld.sock`. And what now? |
| Answer: |
/usr/local/lib/mysql.sock |
