143 reputation
16
bio website schedulecourses.com
location Canada
age 26
visits member for 2 years, 10 months
seen Oct 21 at 15:20

Recent graduate with B.Seng degree. Working for IBM while maintaining small projects, like http://canadiandreamhouses.ca and http://schedulecourses.com.


Oct
25
awarded  Notable Question
Aug
2
answered troubleshooting really slow login on a (linux) machine
Jun
10
awarded  Popular Question
Nov
22
accepted Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Nov
22
comment Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
@mmmshuddup: I was just on a Centos machine and that linux distro uses mysqld, so it will be mysqld for people using Centos and probably other distributions derived from Red Hat. Maybe distributions based on Debian use just mysql without the 'd' for the commands?
Nov
16
comment Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Nope, for me on Linux Mint it's just service mysql start (as root of course).
Nov
15
awarded  Editor
Nov
15
revised Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Corrected title slightly by adding "<database>."; Added that the problem is not just for mysqldump, but also for regular mysql
Nov
15
answered Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Nov
15
comment Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
I did try mysqlcheck --repair at one point near the beginning and it gave errors but I can't remember what they were. I kept looking for a solution after checking here and got something though, posting an answer shortly.
Nov
15
comment Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
It's not just the archive table. All of the tables fail the same way. It just stops trying after it encounters the first error. If I --force it errors out on every table.
Nov
15
comment Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
@gertvdijk: It was not a running copy, as I stated this was an emergency recovery from a dead ubuntu using a live cd (boot from install disc). Also stated in my question, mysqldump is exactly what I'm trying to do. I'm well aware that a copy of the mysql/ directory is not a proper backup.
Nov
15
asked Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Nov
13
awarded  Supporter
Feb
10
awarded  Scholar
Feb
10
accepted Best practices for backing up databases
Jan
11
awarded  Student
Jan
11
awarded  Autobiographer
Jan
11
asked Best practices for backing up databases