Need help with SQL Export Import for bigwalls.net forum

Discussion Topic

Return to Forum List

This thread has been locked

Messages 1 - 11 of total 11 in this topic

deuce4

climber

Hobart, Australia

Topic Author's Original Post - Jun 22, 2013 - 09:22pm PT

Hello programmers.

I'm trying to export a SQL 4 database, then import into a SQL 5 using PHPmyAdmin.

Below are the options for the export:

And I get a number of errors when trying to import in mySQL5 (on a different server). I corrected the TYPE= to ENGINE=, but still get endless errors. THis is the current one:

Is it just that phpMyAdmin can't really do the job? Or is it that the conversion from SQL4 to SQL5 is problematic?

Thanks in advance.

Bill Mc Kirgan

Trad climber

Cedar Rapids, Iowa

Jun 22, 2013 - 09:46pm PT

deuce4,

Is your hosting on a linux server or windows? If the latter the 1&1 support recommends using MS SQL Database.

I'm sure by now you've seen this page, but for discussion I include the link below.

http://help.1and1.com/hosting-c37630/linux-c85098/mysql-database-c37730/import-data-into-your-mysql-database-using-phpmyadmin-a704531.html

IIRC you mentioned using a windows server that you maintain as a fallback solution on another related thread.

I hope you are successful in migrating your data. The bigwalls forum is an important resource and community on the webz. Thanks for all you've done to make it so.

deuce4

climber

Hobart, Australia

Topic Author's Reply - Jun 22, 2013 - 10:19pm PT

It was on 1and1 linux, but I couldn't get the export from a mysql4 db to a mysql5 db following the 1and1 instructions.

Now i booted up one of my images from amazon servers which is a windows server running WAMP. Same errors, so it seems to have something to do with the syntax conversion between versions 4 and 5 of mysql.

I could start a new forum pretty easily but would like to somehow salvage the 10000+ posts from the bigwalls forum, so looking for help.

kunlun_shan

Mountain climber

SF, CA

Jun 22, 2013 - 10:41pm PT

deuce4, I don't know much about SQL, but found this in a quick search. Hopefully its accurate.

From http://stackoverflow.com/questions/15226665/1064-you-have-an-error-in-your-sql-syntax-14-not-null-id-member-mediumi

it says "timestamp should not have length, (It's timestamp not timestamp(14))"

https://dev.mysql.com/doc/refman/5.5/en/datetime.html

mucci

Trad climber

The pitch of Bagalaar above you

Jun 22, 2013 - 10:55pm PT

Have no fear, bunch of folks out climbing this weekend.

We will keep this up front till it gets done.

Viva la bigwalls.com!

deuce4

climber

Hobart, Australia

Topic Author's Reply - Jun 23, 2013 - 05:28am PT

I think its fixed, thanks to Armin from Mallorca for cleaning up the SQL export. Thanks so much!

There might be some glitches, but it looks like the transfer of bigwalls.net to another server is working. Right now it might still go to the old site until the DNS propagates.

Supertopo sure is good for finding the right folks for help.

cheers