MySQL error message: Server has gone away

Our office server processes many files and sends the reports to our remote MySQL server. But over the past week, it's been stopping halfway through with this error message: 2006, mysql server has gone away None of us have seen this before. What changes to we have to make on our end?

ITKE1,068,120 pointsBadges:

Properly remove a MySQL database

Our department has noticed that one of our MySQL databases is becoming unusable due to constant errors (sometimes manual errors). What's the process to remove it? One key - we would like to use the foreign keys again but if we can't, then we can't.

ITKE1,068,120 pointsBadges:

Clear MySQL query cache

My partner and I can't seem to figure out how we can clear the MySQL query cache without restarting our server. It's a SQL Server too. Thanks for the help!

ITKE1,068,120 pointsBadges:

Export and import .SQL file using MySQL command line

A coworker wants to me send me a .SQL file and I have to export / import that file to / from our MySQL database using the command line. What's the command to do that? Could I possible use mysqldump? Quick note: The file might have several constraints too.

ITKE1,068,120 pointsBadges:

Determine disk space on MySQL table

Can I figure out how much disk space my MySQL table is using? The table is in InnoDB. What can I do?

ITKE1,068,120 pointsBadges:

Backup single MySQL database table

Is there a chance I could backup just one single table in a MySQL database? I tried mysqldump but that backed up the entire database. Thanks.

ITKE1,068,120 pointsBadges:

How can I enable the MySQL query log?

Would I be able to enable the MySQL query log function so each SQL query statement that we received from our clients is logged correctly (including time)? Can I use phpMyAdmin to do this? Thank you.

ITKE1,068,120 pointsBadges:

Import MySQL database from terminal

Can my partner and I import out MySQL database from terminal? For some reason - we can't come up with the right syntax.

ITKE1,068,120 pointsBadges:

How to log MySQL queries

How can I turn on my audit logging for a MySQL database? My boss asked me to monitor all of the queries that come in every hour, followed by dumping the log into a file. Is that even possible?

ITKE1,068,120 pointsBadges:

Show MySQL database schema

I'm currently in my MySQL console and I'm looking to find the schema for a specific table. What's the process to do that?

ITKE1,068,120 pointsBadges:

Changing MySQL data type for single column

For MySQL, I'm looking to change the data type (in my columns) from FLOAT to INT. NOTE - there's no current data in there. Can someone tell me the best way to do it?

ITKE1,068,120 pointsBadges:

Checking MySQL tables for storage engine

One of our MySQL databases has several tables that have been using numerous storage engines (specifically InnoDB / MyISAM). Can we find out which table is using which engine?

ITKE1,068,120 pointsBadges:

Sync SQLite data with MySQL

My computer is running SQLite and I'm looking to make it sync correctly with a MySQL server (through an external network). How can I do that? Basically - whenever data is modified in SQLite, I need that data to be modified in MySQL too.

ITKE1,068,120 pointsBadges:

Migrate MySQL database to SQL Server

My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

ITKE1,068,120 pointsBadges:

Backup MySQL database in AWS

I'm working with both AWS and MySQL and I noticed peculiar - my instance disappeared because of hardware failure. For that reason, should I backup my MySQL database so I don't use anything? Thank you.

ITKE1,068,120 pointsBadges:

Delete all MySQL events

Is there a way for me to delete an event in MySQL? For some reason, I can't find the command to do this - I have to do it one-by-one too. Is there a certain query to do this? I tried the below code but it didn't work: "DROP EVENT IF EXISTS (SELECT EVENT_NAME FROM information_schema.EVENTS)" Thanks.

ITKE1,068,120 pointsBadges:

Restoring MySQL database from WAMP

Due to a security scare, I recently re-installed Windows and had to move my WAMP folder to another partition. I just installed WAMP again but I need my old MySQL database. Is there a way to take it from the old / saved WAMP folder to my new partition?

ITKE1,068,120 pointsBadges:

Web development project with streaming video

Hello All. I have a site. Now I want a give a option to visitor to put their video on my web site. For this I have three options. Put a their video URL Put their video Embed Code. Admin put a video. End user can have option 1 and 2. and the video URL or Embed Code directly save in to my database....

Sssintu5 pointsBadges:

MySQL database: Total number of fields in tables

We have a pretty big MySQL database that has millions of records and we have to figure out the total fields (columns) defined in all of the tables. How can we do that? Is there a SQL query for this?

ITKE1,068,120 pointsBadges:

Convert BGL data to MySQL table

Would there be a way for me to convert BGL data to a MySQL table? Can I export it to CSV first, and then to MySQL? Thanks.

ITKE1,068,120 pointsBadges: