Help Importing MySQL into Ravenswood
-
-
- David York
- Hero Rocketeer
- Posts: 326
- Thanks: 0
- I know this isn't the Ravenswood support forum, and this problem is as much my lack of SQL experience, but there a lot of smart people here so here goes. I'm using Ravenswood to redevelop an existing live site. I have everything uncluding a mysql backup. The last thing I need to do is get the mysql set up in Ravenswood so I can get to work on it. When I try to import the database (set up a blank database of the same name then import live data into it) I get the error 'No SQL query'. Obviously I don't know enough SQL or I wouldn't be stuck here. I would greatly appreciate any advice.
-
-
-
- Yves
- Preeminent Rocketeer
- Posts: 9214
- Thanks: 5
- Can this help ? www.webmasterworld.com/forum23/1327.htm
- Yves
-
-
-
- David York
- Hero Rocketeer
- Posts: 326
- Thanks: 0
- Thanks Yves. Initially it looks like my sqldump is too large. I see it mentioned that there is a 10Mb limit when importing a sqldump file. Mine is a bit over 12Mb. I guess I could try splitting it though I'm not sure what a good method for doing that might be. I'm open to any other suggestions
-
-
-
- David York
- Hero Rocketeer
- Posts: 326
- Thanks: 0
-
I found that the culprit for the excessively large database size was a component called Joomlstats. I dropped 10Mb by removing that component. Now, I'm running into this error:
SQL query: CREATE TABLE `jos_banner` ( `bid` int( 11 ) NOT NULL AUTO_INCREMENT , `cid` int( 11 ) NOT NULL default '0', `type` varchar( 10 ) NOT NULL default 'banner', `name` varchar( 50 ) NOT NULL default '', `imptotal` int( 11 ) NOT NULL default '0', `impmade` int( 11 ) NOT NULL default '0', `clicks` int( 11 ) NOT NULL default '0', `imageurl` varchar( 100 ) NOT NULL default '', `clickurl` varchar( 200 ) NOT NULL default '', `date` datetime default NULL , `showBanner` tinyint( 1 ) NOT NULL default '0', `checked_out` tinyint( 1 ) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar( 50 ) default NULL , `custombannercode` text, PRIMARY KEY ( `bid` ) , KEY `viewbanner` ( `showBanner` ) ) ENGINE = MYISAM AUTO_INCREMENT =3DEFAULT CHARSET = latin1
#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 CHARSET=latin1' at line 19
What is a cause for this? A solution?
-
-
-
- Yves
- Preeminent Rocketeer
- Posts: 9214
- Thanks: 5
-
Per what I found in a forum, you need to remove in your database all occurrences of:
DEFAULT CHARSET=latin1
[UPDATE ]Another link that could help you to solve your problem: expressionengine.com/forums/viewthread/34039/
In phpMyAdmin I found I could export my old database using an option entitled ”SQL export compatibility:” and choosing ”mysql 323”. Then it worked when I restored it to my new server. - Last Edit: 17 years 5 months ago by Yves.
- Yves
-
-
-
- Joe K
- Elite Rocketeer
- Posts: 902
- Thanks: 0
-
Hey David,
If you look under components > Joomlastats > configuration > you will see a button called purge database...that will get rid of all the old stats.
Thanks for the heads up about this though as I have this component installed in a few sites.
PS The delete database button is awfully close to the purge one so be real careful - Last Edit: 17 years 5 months ago by Joe K.
-
-
-
- David York
- Hero Rocketeer
- Posts: 326
- Thanks: 0
-
Gah! Thanks for responding guys. This is as fun as installing a roof in a thunderstorm. I'm not having any luck. Each time I get past one issue another pops up. I'm at wits end and not comfortable that I will end up with a working (test) site. I could have set up a fresh install of J! and installed all the extensions I needed in the amount of time I spent trying to import/export live data.
Should I be using Ravenswood or something else? I don't have much hair left to pull out . . .
-
-
-
- Yves
- Preeminent Rocketeer
- Posts: 9214
- Thanks: 5
-
Time to create page: 0.085 seconds