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

    ITKE440,705 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.

    ITKE440,705 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!

    ITKE440,705 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.

    ITKE440,705 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.

    ITKE440,705 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?

    ITKE440,705 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.

    ITKE440,705 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?

    ITKE440,705 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!

    ITKE440,705 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.

    ITKE440,705 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?

    ITKE440,705 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?...

    ITKE440,705 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!

    ITKE440,705 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.

    ITKE440,705 pointsBadges:
  • Error message when importing SQL file: MySQL server has gone away

    I recently tried to import one of my large SQL files through phpMyAdmin but this odd error message keeps popping up: MySQL server has gone away. What does that mean? What can I do about this?

    ITKE440,705 pointsBadges:
  • Linux script to see what data has been changed in the past day

    My department is running a MySQL server on a Ubuntu machine. We noticed that someone changed some data in the past day but not sure of who did / what was changed. Is there a Linux script that could tell us what's been modified? This includes file names and file sizes. Thank you.

    ITKE440,705 pointsBadges:
  • Drop user on MySQL

    Hello again experts! Can I check if one specific user exists in MySQL and then drop him. The user doesn't work at the company anymore. I'm not sure if there's a way. Thanks.

    ITKE440,705 pointsBadges:
  • Open connections on MySQL database

    I currently have administrative privileges in MySQL for my job. For one of our databases on the server, is it possible for me to see all of the open connections?

    ITKE440,705 pointsBadges:
  • When was MySQL table last updated?

    For one of my MySQL tables, I'm looking to add a 'footer' at the bottom of the page saying when it was last updated. Is there a way to do that? Thanks.

    ITKE440,705 pointsBadges:
  • Cleaning MySQL InnodB storage engine

    I have a friend who needs to clean his MySQL InnoDB storage engine because it's still storing data from deleted tables. Is it possible to do that? Does he have to create a new database every single time? Thank you.

    ITKE440,705 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.