polkaroo
Jul 29 2004, 05:42 PM
I'm getting the following error on my mySQL conversion process from Berkeley DB on running mt-db2sql.cgi. So it's connecting to the SQL database, but something's wrong, and I've been through mt.cfg over and over again, I don't know what's wrong.
I've got about three years worth of blogs I'd like to convert?
Thanks for any help...
Loading database schema...
Loading data...
MT::Author
An error occurred while loading data:
No ObjectDriver defined at lib/MT/Object.pm line 105.
polkaroo
Jul 29 2004, 06:17 PM
Never mind, I solved it!
Here's what I did, which, perhaps either I'm not reading right or it's not very clear.
Before running mt-db2sql.cgi, edit your mt.cfg so that you aren't commenting out either the Berkeley DB "datasource" line, nor the rest, so it looks like:
DataSource /home/username/username/mt-db
ObjectDriver DBI::mysql
Database movabletype
DBUser movabletype
DBHost domain.com
Then run mt-db2sql.cgi
... it took a few minutes for the conversion of 3 years worth of blogs (800 entries).. there's no progress bar, but be patient, it's going.
After that, I commented out the Berkeley DB datasource line in mt.cfg and reuploaded it like so:
DataSource /home/username/username/mt-db
ObjectDriver DBI::mysql
Database movabletype
DBUser movabletype
DBHost domain.com
... and now, so far so good.. everything is honky-dory.
Aruna
Jun 17 2005, 07:30 AM
Thank you for your helpful solution! I haven't tried it yet, but I will do it later this evening when I convert to mySQL. Yes, the documentation doesn't make it very clear at times.
sunboat
Jun 18 2005, 07:44 PM
Thank polkaroo.
There is my result, but no data in mysql tables...
Loading database schema...
Loading data...
MT::Author
MT::Blog
MT::Category
MT::Comment
MT::Entry
MT::IPBanList
MT::Log
MT::Notification
MT::Permission
MT::Placement
MT::Template
MT::TemplateMap
MT::Trackback
MT::TBPing
Done copying data from Berkeley DB to your SQL database! All went well.
mwproductions
Jul 11 2005, 02:11 PM
Well, that solved my initial problem, but now I'm stuck waiting for mt-db2sql.cgi to do its thing. Methinks it's not going to happen.
I started the process almost two hours ago, and it got as far as importing 5 comments before, I don't know, I guess it stopped.
Has anyone else seen this happen before or know why it isn't completing its run? I have a lot of posts, but if polkaroo was able to do it with 800 posts, I should be golden...
Help! I'd love to switch to MySQL since it's something I'm (now) a lot more comfortable with.
kelake
Sep 8 2005, 10:22 PM
I thought you might have saved me unfortunately I keep getting
CODE
Table 'mt_author' already exists
error messages
anandg
Apr 27 2007, 02:04 AM
hi
i was done all setting which was You Mention
i am not getting that ""DataSource /home/usename/usename/mt-db""
But still am getting following errore
Loading database schema...
Loading data...
MT::Author
An error occurred while loading data:
No ObjectDriver defined at /var/www/cgi-bin/mt/lib/MT/Object.pm line 172.
plz. help me
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.