Hartsch: Mysqlcheck -c usr_web27_1 focus_gal_img -u root -p*******
Imbert: Error : Incorrect information in file: ‘./usr_web27_1/focus_gal_img.frm’
Heximer: Kukielka: Stored function that calls procedures is really bad idea. Such function can be called anywhere. In WHERE clause of UPDATE statement for example
Heximer: Floogy: The Kuhens is: mysqldump OPTIONS database no “”s
Heximer: Floogy: mysqldump OPTIONS database tables and that’s what you use
Heximer: Floogy: It interprets “usr_web27_1” as database name and usr_web27_1.sql as table name and obviously can’t find it
Kukielka: Salle, erm figures out it was enough to replace mysql with mariadb
Heximer: Kukielka: Although I should be happy about your move :
Kukielka: Whatever, that helped
Heximer: Kukielka: “works” means you have different defaults which you could change
Heximer: Kukielka: You better find out what it was because if it is related to the client config you will have to deal with that again in the future
Freidman: Salle, I don’t know what I should use as name. –skip-lock-tables web27 -r gives: mysqldump: Got error: 1049: Unknown database ‘web27’ when selecting the database
Heximer: Floogy: You are trying to dump a database, but you don’t know its name? :
Oliverio: Hm, what’s the SUBSTRING method to get everything after the 1st delimiter? Can’t seem to get it to work with SUBSTRING_INDEX
Waack: Floogy mysql -uroot -p***** -e’SHOW DATABASES;’ grep web27 usr_web27_1
Baragona: Salle, I don’t be familiar with mysql, so is that the name? I need a database with web27 in it’s name.
Heximer: Oliverio: select substring_index’a,b,c,d,e,f’, ‘,’,-5;
Heximer: Floogy: SHOW DATABASES LIKE ‘web27%’; or use information_schema if you prefer
Heximer: Floogy: You have to use precise name with mysqldump
Conkey: What’s wrong with grep?
Heximer: Floogy: Nothing wrong with grep, just redundant :
Heximer: Floogy: All you need is to follow the Kuhens for mysqldump. mysqldump –help will certainly help you
Heximer: Oliverio: You can use combination of LTRIM and LOCATE too if you wish
Oliverio: Salle: But I don’t know the length beforehand
Bogg: Ooops, ok, # mysql -uroot -pR8VnXKCZ -e”SHOW DATABASES LIKE ‘%web27%’;”
Heximer: Oliverio: Yep. If you want to search for parts of sucg strings don’t store them together. In your case split the email and domain name and also if necessary splt the domain name in separate columns
Oliverio: Salle: That’s what I’m doing now – splitting email into user, domain, and tad
Cardosa: Ok, so the the redirection or option -r should be wrong, because without that I get something dumped.
Heximer: Floogy: mysqldump file.sql works just fine
Iburg: Hi guys! Why locking reads, update, delete statements works as in Read committed mode?
Resendiz: In repeatable read mode.
Salome: Salle, I found the culprit. It was a copy and paste error, that introduces a space in the output filename, at least I guess so. https://bpaste.net/show/6a0764d15a89
Heximer: NoOova: Why something works is weird question
Heximer: Floogy: Don’t copy/paste :
Hemeon: But there is still an issue. I guess that dump will not help, because it lacks the information and tables from ./usr_web27_1/focus_gal_img.frm , right?
Shetter: Sorry, I don’t know much about mysql :
Heximer: Floogy: ./usr_web27_1/focus_gal_img.frm is table definition
Heximer: Floogy: That’s separate problem.
Roura: So, the backup might be intact and ok, now?
Heximer: Floogy: If this table is corrupted there are various things that can be done, but better find someone who knows MySQL
Heximer: Floogy: How could we possibly know how important this table is for your backup?