Changing Hosts Need help exporting DB

[sfera]

I have backed up my catalog directory and uploaded it to my new host. Now with my current host how do i export the database?

 

I went to phpMyAdmin and selected the database and clicked export...then it gave me an sql file. I took this sql file to my new host then to phpMyAdmin, created a new DB, and ran the sql file and got this error

 

Error

 

SQL-query:

 

-- phpMyAdmin SQL Dump

-- version 2.6.2-pl1

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Jul 19, 2005 at 06:08 PM

-- Server version: 4.1.11

-- PHP Version: 4.3.11

--

-- Database: `studior`

--

CREATE DATABASE `studior` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

 

MySQL said: Documentation

#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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line

 

 

what should i do?

[Guest]

Funnily enough I had this last night, as I'm switching too.

 

I think it's something to do with switching from MySQL 4.x to MySQL 3.23.x.

 

Easiest thing to do here (and it worked !) is open up the whole SQL file in Notepad or another text editor (back it up first though - just save as ORIGINAL or something), then File>Replace> type in the top box, without the quotation marks :

 

") ENGINE=MyISAM DEFAULT CHARACTERSET=latin1_swedish_ci" <- you may need to adjust this to fit whatever your statement says in the last line - check the first table and see what it is

 

and in the bottom box

") " <-note the space after the bracket - essential, as you'll find the next bit of the statement, probably AUTO INCREMENT and a value, will then just slot in its place.

 

Then select Replace All, and it'll remove the statement from all the tables. Save the file and upload that instead.

 

As I say, it worked for me -

 

Let me know if it works :)