#1064 - error trying to import database after update

[aaronb4146]

Hi I am trying to update from 1.2.6 to the latest 1.3.6.

I have followed everything in the doc folder and tried help from here but nothing is working. I have made a backup of my database in SQL. I have created a new database on phpMyAdmin.

When I tried to import the backed up sql into the new one I got a error that the database already exists (#1007) after a search on the internet I found that I had to change the .sql file from :

CREATE DATABASE: [original]
USE : [original]

to

CREATE DATABASE : [new]
USE : [new]
(is this correct??)

After I done this and tried importing again I got a different 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

'CREATE DATABASE `new` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line 1

This is my first time with SQL so please feel free to mock and tell me the answer in the most simple 4-year old terms so I can get it all running, I have included a screenshot of my error incase it is needed.

Any help would be great

Cheers

Aaron

[pivey]

Aaron,
removethe option "Enclose table and field names with backquotes"
Causes trouble on larges indexes.

make it simple.
Export your database using only
In STRUCTURE:
Add DROP TABLE
Add AUTO_INCREMENT value

In DATA:
leave default

If the database is not heavy, best is to open exported .sql file and to copy/paste the data running sql queries.

[aaronb4146]

it worked

cheers for the help and for not mocking me!

skunked