• How to store a MySQL database in source control

    My department is currently working on an application and we have to store our MySQL database in source control. What's the best way to do that? We were thinking of having two different files: Script for the tables Inserts for the sample data Would that be a good way to do it? Thank you very much.

    ITKE413,725 pointsBadges:
  • Deleting views from MySQL database

    I'm trying to delete all views from my MySQL database. How can I do that? I'm stuck. Is there a query I can use? Thank you so much.

    ITKE413,725 pointsBadges:
  • Storing XML data in MySQL database

    How can I go about storing my XML data into a MySQL database? It's pretty complex data so I want to make sure it's done the right way. Do I have to use foreign keys?

    ITKE413,725 pointsBadges:
  • How to import MySQL database dump file in Java

    Is there a way for me to import my MySQL database dump file programmatically in a Java program? I've tried the below code but nothing is working. Connection conn = dbConnectionSource.getConnection(); Statement stmt = conn.createStatement(); stmt.execute(FileUtils.readFileToString(new...

    ITKE413,725 pointsBadges:
  • MySQL: Get last deleted ID

    In MySQL, is there a way for me to get the actual last deleted ID after a row has been deleted? Perhaps a command / query that's similar to getting the last inserted ID. Thanks.

    ITKE413,725 pointsBadges:
  • Error when accessing MySQL database through web admin console

    For the past week, I've been trying to access a MySQL database through the web admin console. But I keep getting this strange error message: SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Got error 28 from storage engine. What should I do?

    ITKE413,725 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • Partition MySQL database by date automatically

    My colleague and I have a MySQL database that we need to partition by date (especially the month / year). But when we add new data, we don't want to update the database manually. How can we do it automatically? What's the process? Thank you.

    ITKE413,725 pointsBadges:
  • Incremental backup of MySQL log files

    We're currently using MySQL and several of our tables are InnoDB. This is followed by a replication to a slave server. Now, here's what we need to do: Backup our MySQL log files on a daily basis. What's the best way to do an incremental backup? Thanks!

    ITKE413,725 pointsBadges:
  • Add comment to SQL code in MySQL

    One of my co-workers sent me a SQL code and I need to add a comment to it. Is there a way to do that? This is currently for MySQL. Thank you so much.

    ITKE413,725 pointsBadges:
  • See if column exists in MySQL table

    Would I be able to see if a particular column / field name exists in a MySQL table? What's the best way to do that? Appreciate the help.

    ITKE413,725 pointsBadges:
  • Convert MySQL database to SQLite

    Our department has one small MySQL database (roughly 6/7 tables) that we have to convert to a SQLite database. We're not sure of the process but are there any tools out there that can do this automatically? Thanks so much.

    ITKE413,725 pointsBadges:
  • Recover MySQL deleted rows

    On MySQL, all of my data was deleted accidentally and I'm hoping there's a way to recover all of it? Is it possible? Thank you so much.

    ITKE413,725 pointsBadges:
  • Transfer data between two MySQL databases

    Is there a way for me to transfer my data between two different MySQL databases? I'm looking to use a code not a tool. Thank you very much.

    ITKE413,725 pointsBadges:
  • Create MySQL database with a dot in name

    Would MySQL allow me to create a database that has a (.) in its name? Several collegues told me that it is not possible but I wanted to check with you experts. Thanks!

    ITKE413,725 pointsBadges:
  • Backup MySQL database on Windows Server

    Would I be able to backup my MySQL database automatically (throughout each day) to my designated Windows Server? If that's not possible, how about a email attachment? Thanks for the help.

    ITKE413,725 pointsBadges:
  • How to clone a MySQL database

    We currently have a MySQL database on our server and it has roughly 100 tables. We have to clone the entire database but it needs to have a new name / copied data. What's the process for this? Thank you.

    ITKE413,725 pointsBadges:
  • Maximum size for MySQL table

    Does anyone know the maximum size for a MySQL table? Is it close to 5-10 million for 80GB. If that's the case, should I compress all of my data? Or should I split the table instead?

    ITKE413,725 pointsBadges:
  • MySQL database tables modified

    For my MySQL database, how can I figure out which of my tables have been modified / changed in the past hour? My tables don't have a timestamp column.

    ITKE413,725 pointsBadges:
  • How to archive live MySQL database

    Our department has a live MySQL database and we want to archive the data daily so we can run different queries on it (without affecting the live database). How can we go about this? Would MySQL replication work for this?

    ITKE413,725 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following