1
vote
1answer
156 views

MySQL Binary Logging Format - Disk Filling Up

I have a MySQL server instance configured with binary logging enabled. I don't do any replication, but the binary logs are part of our recovery plan - to be able to replay all the transactions since ...
0
votes
1answer
149 views

copy a MySQL table which has data in ibdata file

I have a database in MySQL with several tables. Some of the tables only have .frm files. Some have .frm .mdy .mdi I believe data for the .frm tables is in the ibdata file. There is a lot of data in ...
1
vote
2answers
75 views

Is there any option to restore data after deleting from a MySQL table

There are some rows in a table, by mistakenly I had deleted all rows from the table and data got commited. So is there any way to restore data for that table. I am not having backup of the database. ...
0
votes
2answers
50 views

moving data between webhosts

I currently have an application (php/mysql) running on 3 different web hosts. At each host, I have the typical cpanel/phpMyAdmin type of access. I currently have clients spread across all 3 servers, ...
1
vote
3answers
213 views

moving large amount of MYSQL data to another host

I have about a large MYSQL DB(3 TB) that I need to move to another host, which is not yet up. what's the best approach? I plan to either zip the mysqldump or the binary, what is the choice of the zip ...
1
vote
1answer
767 views

MySQL failed to start after killed a long running “LOAD DATA INFILE” process

I killed a MySQL process which is running a LOAD DATA INFILE command to load a 9GB .csv file into a table in a InnoDB database. Now, when I run mysql DATABASE, it just stopped and showed Reading ...
0
votes
1answer
697 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...
1
vote
2answers
425 views

POST data not being received

I've got an iPhone App that is supposed to send POST data to my server to register the device in a MySQL database so we can send notifications etc... to it. It sends it's unique identifier, device ...