Need help with SQL Export Import for bigwalls.net forum

Search
Go

Discussion Topic

Return to Forum List
Post a Reply
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:

options for export
options for export
Credit: deuce4

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:

import error
import error
Credit: deuce4

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
John Mac

Trad climber
Littleton, CO
Jun 23, 2013 - 12:04pm PT
Thanks to everyone that helped out. .
mucci

Trad climber
The pitch of Bagalaar above you
Jun 23, 2013 - 12:21pm PT
BAM!
mwatsonphoto

Trad climber
los angeles, ca
Jun 23, 2013 - 02:52pm PT
I'm not much of a poster on bigwalls but I do spend a lot of time reading there... I'm glad this isn't going away!
Jaybro

Social climber
Wolf City, Wyoming
Jun 23, 2013 - 05:03pm PT
Cool!
Mungeclimber

Trad climber
Nothing creative to say
Jun 24, 2013 - 06:15pm PT
ah, this is where it all happened. :)

Thx Armin and Deuce!

Bigwalls.net lives to fight another day!
Messages 1 - 11 of total 11 in this topic
Return to Forum List
Post a Reply
 
Our Guidebooks
Check 'em out!
SuperTopo Guidebooks


Try a free sample topo!

 
SuperTopo on the Web

Review Categories
Recent Route Beta
Recent Gear Reviews