All Questions
7 questions
0
votes
1
answer
818
views
PHP How to handle/parse csv files that have missing columns
I have many csv files generated by a third party, for which I have no say or control.
So each day I must import these csv data to mysql.
Some tables have correct matching number of columns to header.
...
- 1,917
0
votes
1
answer
8k
views
Repairing mysql myisam table using `Repair Table` vs myisamchk
I am working on a script that will be a cronjob that will look at the tables in database and repair any that need it. They are myisam tables in a mysql database. My question, is there any reason to ...
- 19.6k
3
votes
6
answers
635
views
Find "problematic" rows in a mysql table that will fail to export
I wanted to backup my database with PHP.
I tested the linked script but it was never ending, I tried to prepend the repair $table before the query but it didn't help.
So I figured out if I just skip ...
- 20.1k
2
votes
1
answer
919
views
Can't connect to MySQL - missing stuff after power failure?
I'm trying to connect to an application. There was a power failure that corrupted the hard drive, and after taking a backup from it externally, I've managed to get the application back up. Looking at ...
- 12.7k
1
vote
2
answers
1k
views
remove carriage return character from php tidy repaired html string
I would want check if string is a valid xhtml/html.
I have some html string get by tinymce editor. I would want in first time before save it into mysql database check if this html string is valid. I'...
- 5,651
0
votes
1
answer
617
views
Repair SQL file or DB
I found that my DB.sql has error shown below, i did not process it with addslashes in php so now instead of 'O\'Brien' it is 'O''Brien'. Making exporting and importing sql impossible.
(228, '', '...
- 1,913
0
votes
2
answers
326
views
Repair Data Integrity
I think this is a long-shot, but here it goes:
The basic question is: how does a development team beginning to repair data integrity on a large, damaged dataset?
The company I'm helping out has a ...
- 5,226