• 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.

    ITKE1,000,710 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!

    ITKE1,000,710 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.

    ITKE1,000,710 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.

    ITKE1,000,710 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.

    ITKE1,000,710 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.

    ITKE1,000,710 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.

    ITKE1,000,710 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!

    ITKE1,000,710 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.

    ITKE1,000,710 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.

    ITKE1,000,710 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?

    ITKE1,000,710 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.

    ITKE1,000,710 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?

    ITKE1,000,710 pointsBadges:
  • How to backup MySQL users

    Would it be possible for me to backup all of our MySQL users / privileges? Would something like MySQLdump work? Thanks!

    ITKE1,000,710 pointsBadges:
  • Setting MySQL row as read-only

    In my MySQL row, I have very important data that I don't want changed at all. Can I set that row to read-only so no one can update / change it? If that's not possible, is there another way I can make sure the data isn't changed? Appreciate the support.

    ITKE1,000,710 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE1,000,710 pointsBadges:
  • What’s the maximum MySQL concurrent connections?

    I work for a community college and I'm looking to revamp our social networking efforts (particularly the website). To do that - I have to setup a MySQL database. To start - the application can hold roughly 10,000 users. So my question is: Is there a maximum number of concurrent MySQL connections?...

    ITKE1,000,710 pointsBadges:
  • Migrate MySQL database to MongoDB

    I'm looking to change databases for development purposes. I'm thinking of going from MySQL to MongoDB. What's the best way to do this? Thanks!

    ITKE1,000,710 pointsBadges:
  • Do we have too many records in our MySQL InnoDB?

    We currently have a MySQL InnoDB that has millions of records. We're worried that it's too much for the database. Would you agree? Can the database handle this? Just because we noticed that several of our queries are much slower now. Thank you.

    ITKE1,000,710 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