Help - Search - Members - Calendar
Full Version: Using mysql
Movable Type Community Forum > Additional Resources > Tips and Tricks
badnews_3
I recently installed moveable type for the first time and am using mysql. I have read that you can use MT without a database. I was just wondering what will happen if you don't use a database.

Thanks
maddy
You must use one of the database options. Without database support, MT will not function.
badnews_3
Ohh Okai biggrin.gif

Thanks maddy.
ingmar
QUOTE (badnews_3 @ Feb 24 2004, 06:38 AM)
I recently installed moveable type for the first time and am using mysql. I have read that you can use MT without a database. I was just wondering what will happen if you don't use a database.

Thanks

Don't get maddy wrong, though. The default option is to use a flatfile Berkely-Style database. Well, it's not as sophisticated, you don't get as many direct-editing capabilities, and it is in general not as performant.

So, using MySQL certainly isn't the wrong choice.
enrico
hey, i want to convert my site to blog to use mySQL
i found the instructions here
but the problem is i don't have the mt-db2mysql.cgi file
i donwloaded the upgrade pack and it is there, but there are many files there and i was wondering if could just use the conversion file and not upgrade the entire system.
i made alot of changes in the system (template wise) and don't have the time to change everything again.
ingmar
QUOTE (enrico @ Feb 24 2004, 09:46 AM)
the problem is i don't have the mt-db2mysql.cgi file
i donwloaded the upgrade pack and it is there, but there are many files there and i was wondering if could just use the conversion file and not upgrade the entire system.

i made alot of changes in the system (template wise) and don't have the time to change everything again.

Yes, you can. Anyway, I don't think your templates would be affected (not withstanding the fact that you can & should make a backup before upgrading.)

What might pose a more serious problem would be patches to the MT code itself, these might get overwritten by an upgrade.
enrico
i tried to upgrade and i got a 500 error from my server when i tried to run mt-db2mysql.cgi

why?
the file was "chmod"ed to 777
and i also tried removing the driver name line...
no cigar... sad.gif

help huh.gif
thanks.
ingmar
QUOTE (enrico @ Feb 25 2004, 02:59 PM)
i tried to upgrade and i got a 500 error from my server when i tried to run mt-db2mysql.cgi

the file was "chmod"ed to 777
and i also tried removing the driver name line...

You _did_ follow the instructions here to the letter, right? Did you provid a valid password, host, db name etc?

If everything else fails, you might want to consider upgrading your installation of MT.
kadyellebee
What version of MT are you trying to upgrade from?

Kristine
girlie
The permissions on the file should be 755, not 777.
enrico
hey, thanks it worked. wrong chmod.

about this:
QUOTE
Don't get maddy wrong, though. The default option is to use a flatfile Berkely-Style database. Well, it's not as sophisticated, you don't get as many direct-editing capabilities, and it is in general not as performant.

what capabilities does he refer to ?
enrico
damn damn damn
i got this error during rebuild:
CODE
MT::App::CMS=HASH(0x812e968) Use of uninitialized value in concatenation (.) or string at lib/MT/ObjectDriver/DBI.pm line 74.

help?!

i'm using version 2.64 and used the update mt-db2sql.cgi from the 2.664 update pack
ingmar
QUOTE (enrico @ Feb 26 2004, 07:08 PM)
What capabilities does he refer to ?

Well, I can use standard SQL queries to directly manipulate the underlying MySQL database; with PHP it's relatively painless. I use a script, e.g., to close comments for a given entry:
CODE
mysql_query("UPDATE mt_entry SET entry_allow_comments = 2 WHERE entry_id = $id")


I would not know how to do that with a berkely db.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.