Categories

Featured templates

Joomla Troubleshooter. Error #1064 during template dump.sql import

Chris Diaz February 21, 2012
No votes yet.
Please wait...

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

Joomla Site Templates
This entry was posted in Joomla! Tutorials and tagged 1064, archived_tutorial, database, dump, Joomla, SQL. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket