| chadmaynard | cld2: you have a defaults file? |
| cld2 | ? sorry. ive never installed before, only used after the fact. is it called 'defaults' ? |
| chadmaynard | no. my.cnf |
| Xgc | chadmaynard: Consider trying to something like hours and minutes. To determine if 05:10 is < 06:09, you don't test 05<06 and 10<09 |
| cld2 | yeah, in /etc/mysql chadmaynard: thanks |
| chadmaynard | ok. you see datadir? |
| cld2 | yeah, thanks very much. just change it? |
| chadmaynard | yup and /etc/init.d/mysqld restart | reload |
| cld2 | do I have to move the contents to the new location? to bring the existing mysql database and stuff over? |
| chadmaynard | and you'll need to move the mysql folder into that new location if it doesn't exist and set OS level permissions cld2: yes |
| cld2 | great, thank you very much. |
| chadmaynard | Xgc: Oh i see now |
| caotic | FYI, that query didnt work the join part, on your defense, im running those queries in a MSSQL, im doing some migration to mysql |
| cld2 | how about this, im going to be putting some important test data into 1 db, the rest I dont care about. would it be easier/better/smarter just to dump that one db to a flatfile everynight and backup that instead of moving the entire datadir to my raid5 partition? |
| Xgc | caotic: Which SQL are you talking about, specifically? |
| chadmaynard | cld2: mysqlhotcopy is the best/fastest backup option |
| cld2 | chadmaynard: thanks. ill look into that. appreciate the help and info. |
| chadmaynard | !man mysqlhotcopy |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/client-utility-overview.html |
| cld2 | thanks. |
| Xgc | caotic: MSSQL would handle the queries we were discussing earlier, possibly needing some minor adjustment. MSSQL doesn't always like standard SQL. |
| chadmaynard | the newest version is better about that isn't it? didn't they try to conform? |
| flaccid | chadmaynard: ok that was sweet. plesk had an issue, but i fixed that so its all good. thanks for your help |
| Xgc | chadmaynard: Microsoft, conform? |
| chadmaynard | lol. i said try....... i guess thats even sillier well that's what i heard. Maybe propoganda |
| Xgc | chadmaynard: They usually conform pretty closely with the standard. The microsoft standard. It's tough to throw stones at MS when Oracle treats '' as null. |
| caotic | Xgc: I dunno what version, but could be anything older that 4 or 5 years Xgc: i know MSSQL doesnt follow the standards, i just mentioned it for you to know |
| Xgc | caotic: No problem. Do you knwo which version? |
| caotic | nope |
| chadmaynard | Oracle treats '' as NULL? thats rough |
| action | Xgc nods. |
| Xgc | nods. |
| caotic | Xgc: do you have a query to find that out ? |
| Xgc | caotic: SQL Server Management Studio should tell you. |
| caotic | i dont have htat |