Database error.

[Optimit]

Hey guys,

I am trying to upload a database that was made on a server running MySQL 4.1.18 to a Godaddy server running MySQL 4.0.24.
After uploading the db, I get this error.

Content visible to registered users only.

Any ideas how to get the dump rdy for an older version of MySQL?

[anon]

for the hell of it, try cutting and pasting this

Content visible to registered users only.

[Boby]

Hello!

Try this:
Content visible to registered users only.

I have that problem too, each time I want to import something to my root-server I have to remove the last piece because it's not supported :(

If you have something in your banlist table, you can keep AUTO_INCREMENT=xyz ;

Boby

[Optimit]

I actually removed all instances of Content visible to registered users only., and it got past that error, and into another. I will try your suggestion.

Thanks to both of you.

[Boby]

Try removing also ENGINE=MyISAM

[Optimit]

Appreciate the help guys. Still got an error.

Content visible to registered users only.

[stevan]

If you read at some of the news sites for seo and such you will see a lot of people have problems with scripts at Godaddy Servers for some reason . I have no idea why . But I had a problem with my host using phplinkdirectory on the send mail BUT I emailed them and they fixed the problem for me.


STEVE

[David]

Your mysql user priveledges may not allow you to
DROP TABLE
Try removing that line.

[anon]

ok, if that is the case, then replace that DROP TABLE with TRUNCATE IF EXISTS `WHAT_EVER_TABLENAME`;

[greenway]

Save the database again,and select SQL export compatibility: POSTGRESQL :wink:

Then just upload to the new server.