meta user
network profile
| bio | website | |
|---|---|---|
| location | Cincinnati, OH | |
| age | 42 | |
| visits | member for | 8 months |
| seen | 18 mins ago | |
| stats | profile views | 104 |
If you question the superiority of the relational model... you're doing it wrong.
|
Apr 22 |
comment |
Is there a way to recover this database (MySQL) Only the first message is relevant -- the others are all side-effects of it. Check the file permissions... everything in the data directory needs to be owned and writable by the appropriate system user account, typically 'mysql' is the correct user. |
|
Apr 21 |
answered | Is there a way to recover this database (MySQL) |
|
Apr 21 |
comment |
Is there a way to stop MySQL Replication on the master? Why do you want the master to stop replicating data to the slave? Is it because you do not want to use replication any more, or are you trying to solve a different problem? The best answer, and a safe answer, to your question cannot be given, without that information. |
|
Apr 19 |
comment |
Loading data in mysql using LOAD DATA INFILE, replication safe? I haven't benchmarked the other method. I rarely use LOAD DATA INFILE, since I often deal in files that aren't plain text, and at any rate I prefer to have an external application parse the file and do primitive structural validation. In some cases, my "loader" applications are designed with the ability to monitor Seconds_Behind_Master on the slaves while they are running, and will actually throttle themselves to write less aggressively to the master if or when a replication lag occurs. |
|
Apr 19 |
answered | Single slave - multiple master MySQL replication |
|
Apr 18 |
answered | Loading data in mysql using LOAD DATA INFILE, replication safe? |
|
Apr 17 |
comment |
MySQL users corrupt During the times when you "cannot log in" do you see a specific message? Was your server newly installed as 5.5.20 or was it upgraded from a previous release? |
|
Apr 17 |
comment |
MySQL users corrupt The answer to "what version are you running?" is found with SHOW GLOBAL VARIABLES LIKE 'version'; |
|
Apr 17 |
comment |
best way to copy data from MSSQL db to MYSQL DB(remote) What is "linking in SQL"...? Federation? Using mysqldump piped to the mysql client? Please describe how you're doing it now, in a bit more detail, as there are some optimizations you may not be doing. |
|
Apr 17 |
comment |
MySQL and window functions The community edition of MySQL Server is not a limited subset in any meaningful sense. The differences are in add-ons and plugins that do not affect core functionality. |
|
Apr 17 |
answered | MySQL - Connection blocked because of many connection errors - How to find root cause? |
|
Apr 17 |
answered | Optimizing ORDER BY for simple MySQL query |
|
Apr 16 |
comment |
Avoiding Multiple Queries when Searching for Records Associated with a Set of RecordsDISTINCT is commonly overused, and seems unnecessary here... it may be hurting performance my requiring the server to take extra steps to ensure distinctness of a result-set that shouldn't contain duplicates. Consider posting the output from EXPLAIN SELECT of the query... with and without the DISTINCT. |
|
Apr 16 |
answered | mysql duplicate entry error 1062 when restoring backup |
|
Apr 16 |
comment |
MySQL users corrupt What version of 5.5 are you running? |
|
Apr 16 |
comment |
Error log - What does this mean and what can I do about it? +1 ... never a good idea for MySQL or any other service to be open to Internet without strong justification. Also worth mentioning, given OP's version, is the security vulnerability in versions before 5.5.24 had a serious potential security flaw these attackers might be trying to exploit. Official binaries were not affected but compiled-from-source and 3rd party builds may have been, depending on the underlying libraries used for the build: seclists.org/oss-sec/2012/q2/493 |
|
Apr 16 |
comment |
how to resolve ELFCLASS32 error in mysql for UDF lib_mysqludf_sys.so You apparently have downloaded a copy of the 32-bit version of lib_mysqludf_sys.so -- right? Trying to install that on a 64-bit MySQL Server is why you got the ELFCLASS32 error... so, where and how did you get that file? In the same place, you should see the source file lib_mysqludf_sys.c which you compile with gcc using the command we've been referencing. |
|
Apr 13 |
awarded | Nice Answer |
|
Apr 13 |
comment |
ERROR 1034 (HY000) : Wrong aligned block, while importing in mysql I agree...er, I mean +1 ... installing MySQL on another machine and trying to restore the dump file there is a good idea, because this error is almost certainly nothing to do with the dump file and everything to do with something corrupt or some defective hardware on the server where you're attempting to restore. The errors seem like they must be coming from storage/myisam/mi_check.c and nothing in the dump file should be able to cause alignment errors in the storage engine. |
|
Apr 12 |
answered | Recursive query in mysql |
