Hi Everyone, i am facing an issue while importing my database via the SSH, when i import the database i get this error .
ERROR 1064 (42000) at line 31734: 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 '‘C:24:“WPSEO_Sitemap_Cache_Data”:152414:{a:2:{s:6:“status”;s:2:“ok”;s:3:“xml”;s:’ at line 2
I have no idea why this is happening, plus my database size is also huge and its 1 GB. Please help me out my site is down from days.
I was using vestaCP and exported the .sql file via the Phpmyadmin and now i reinstalled my server and vestaCP and now i cant import please help me out.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
The most common reason for this type of error is if the line reported includes a special character or in some other way breaks the MySQL syntax. Your best option is to review this line manually in a text editor and make adjustments to comment out special characters that may be causing the issue.
There are options that can be selected in PHPMyAdmin or mysqldump that will help resolve this type of issue in the export but without access to the original server this is the best option.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.