- Web templates
- E-commerce Templates
- CMS & Blog Templates
- Facebook Templates
- Website Builders
Joomla Troubleshooter. Error #1064 during template dump.sql import
February 21, 2012
Error #1064 – 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 during dump.sql file import.
If you got the error #1064 while importing Joomla template dump.sql file into your database please do the following:
1. Open dump.sql file with your editor (we recommend Notepad++)
2. Using CTRL+A combination select whole file content and copy it.
3. Open your database management tool (phpMyAdmin)
4. Select your database and from the top menu click SQL
5. Paste the dump.sql file content into the Run SQL query/queries on database field
6. Click Go to start import