Pages with tag MySQL
Converting a MySQL enum for use in SQLite3 I've got a database & website I want to move from using MySQL to using SQLite3. Well, I think I want to use SQLite3. Their document saying what sorts of uses make sense for SQLite3 are directly in line with my website, and I do want to remove some of the load off of my MySQL server so that it can have cycles free for more important purposes.<br /><br />However I've run into a couple troubles converting the schema so that it fits within SQLite3's limited SQL support. Turns out that it doesn't support some column types and indexes. And that the SQL produced by mysqldump contains some MySQLisms which SQLite3 just doesn't understand.
How to restore a MySQL database and tables from .frm .ibd or .myd raw database files Consider a situation - you've got a well tuned MySQL database server running some popular websites. The sites are implemented with Drupal and Wordpress, but using MySQL to store the content and settings. You think everything is fine, until one day you look at Google Analytics and are aghast to see zero traffic for the previous two days. You go to the websites and are greeted by a 404 error, with the server saying there's nothing there. You try logging into the server, but cannot, your login attempt is refused. You contact the hosting provider for help, and they tell you the directory containing all your websites and other files is completely empty. Oh.. and there's a note left behind from someone giving an http-something-or-other URL to click on, demanding payment in order for the server to be restored.
Setting up LibreOffice to access MySQL database with JDBC driver I wanted to try using LibreOffice Base on Mac OS X to play with a MySQL database. I thought it would be easy, just connect to the database and start doing queries, maybe even pull data into a LibreOffice spreadsheet for advanced data munging. But doing the obvious thing got me messages like "No Java Installation found" and "the driver class com.mysql.jdbc.Driver could not be found". Further, yahoogling with some obvious search phrases turned up nothing. Finally, going to LibreOffice.org and looking at the official LibreOffice Base documentation showed no instructions on setting up JDBC MySQL with LibreOffice.