Moved to a new server, and no connection.

[birdoasis]

I've moved everything, verified that all the files moved with my logs.

Now I'm getting the connection problem page.
restored mysql file.
Configure.php is the same from the server.
un and pw the same as on the old server.

Any ideas?

John Patrick

[Kim]

Database is created, user added with all permissions? Double checked that host doesn't add prefix to DB name?

[birdoasis]

I looked at the db, and it's the default db. duh.

I attempted an import of the export from the old server and I get a mysql version error. it's the same version except the old version has -log after it.

Current Server

Mysql 4.1.21. Standard

old server

Mysql 4.1.21. standard-log

[birdoasis]

Ok, this is the error. I have syntax error in there. I'm going to go look it up and see how to fix it. I'll post it in here.

Error

     SQL query:     
               CREATE  TABLE  IF  NOT  EXISTS  "address_book"( "address_book_id"int( 11  )  NOT  NULL ,
 "customers_id"int( 11  )  NOT  NULL default  '0',
 "entry_gender"char( 1  )  NOT  NULL default  '',
 "entry_company"varchar( 32  )  default NULL ,
 "entry_firstname"varchar( 32  )  NOT  NULL default  '',
 "entry_lastname"varchar( 32  )  NOT  NULL default  '',
 "entry_street_address"varchar( 64  )  NOT  NULL default  '',
 "entry_suburb"varchar( 32  )  default NULL ,
 "entry_postcode"varchar( 10  )  NOT  NULL default  '',
 "entry_city"varchar( 32  )  NOT  NULL default  '',
 "entry_state"varchar( 32  )  default NULL ,
 "entry_country_id"int( 11  )  NOT  NULL default  '0',
 "entry_zone_id"int( 11  )  NOT  NULL default  '0',
 PRIMARY  KEY (  "address_book_id"  ) ,
 KEY  "idx_address_book_customers_id_zen"(  "customers_id"  ) 
) AUTO_INCREMENT  =2;

     
      MySQL said:  
  #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 '"address_book" (
  "address_book_id" int(11) NOT NULL,
  "customers_id" int(11' at line 1

[Merlinpa1969]

its the marks around the table and cell names

[birdoasis]

I tried it again without the "Create Table if Not Exist" and I was able to upload the db.

I did have to delete the db before I could get it to upload, which made no sense since I had the drop command in the script.

After I deleted the db I was able to import the db.

Still can't connect but I suspect that's simply a password problem.

Which I'll start a new thread for. I searched and don't see the answer. And it's not in the book. haha.

[birdoasis]

Merlinpa1969,

Times like this when I wish I had hosted with you. haha. I decided to get a resellers account for more bandwidth for my video training idea. I'll tell you more about that later.

You would have had this thing moved by now I'm sure. But I wouldn't have learned anything.

I may still come running to you so stand by. haha.