MySQL is the most widely used multi-user, multi-threading SQL database management system. To optimize MySQL performance, a DBA should have reasonable knowledge of MySQL system variables. This article covers the basics of MySQL server optimization. We will first discuss MySQL optimization during installation. Then we will discuss the seven most important and common system [...]
This article describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (say we can call it as slave), and all updates to the database on the master server are immediately replicated to the database on [...]
Question: I use MySQL 5.0.13RC under Linux I’m trying to create a table with 70 foreign keys and the next message appear : ERROR 1069: Too many keys specified. Max 64 keys allowed Can I avoid/modify this restriction easily? Thank you all.
Question: When i register then get erro Database error in vBulletin 3.8.4: Invalid SQL: INSERT INTO user (options, parentemail, email, username, salt, passworddate, password, usergroupid, languageid, usertitle, customtitle, showbirthday, birthday_search, birthday, timezoneoffset, ipaddress, displaygroupid, joindate, lastvisit, lastactivity, autosubscribe, showvbcode, threadedmode, reputationlevelid, reputation, pmpopup, maxposts, daysprune, startofweek) VALUES (45096311, ”, ‘minhtan@yaoo.com‘, ‘ngominhtan’, ‘=M{‘, FROM_UNIXTIME(1263954171), ‘d5b85766342f5515dc90e10a9393da52′, 2, [...]
Question: Hello If I try and load a page from the my main vbullletin for example: http://community.basenotes.net/showt…32#post1251532 I am faced with an error in firefox like this Content Encoding Error The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression. I’ve not changed any settings [...]
Question: I am trying to create a form where I can cut an paste records in a textarea and submits each record as new row in mysql. Example: I have records such like this. —- Toyota Honda BMW —- I would like to copy the text and paste it in a textarea then hit submit. [...]
Question: I have to update my mysql db. I have to update a field if it matches 1 of 184 zipcodes. I have a list of zipcodes but dont have any idea of how to created the statment. UPDATE `cart`.`cart_cust` SET `s_county` = ‘2′ WHERE (zipcode could be one of 184) Solution: UPDATE `cart`.`cart_cust` SET [...]
Question: I’m using MySQL 5.1, and I’m trying to calculate a percentage. Basically, I have a huge database with all the information regarding projects. What I’m trying to do is the following: all the user requirements are stored in the database. Some of them will be implemented through configuration and others through development. I’m trying [...]
Question: I have 2 tables.. tblDetails HFID | TID | Grade ——————– 1040 | 1 | NULL 1040 | 2 | NULL 1040 | 2 | NULL 5670 | 3 | NULL 5670 | 4 | NULL 8879 | 5 | NULL tblMain TID | DPI ————– 1 | 3.4 2 | 5.6 3 | [...]
Question: Hi, I have a text input box for users to leave messages. I have noticed that if one of them uses an ampersand the rest of the text is cut off and not stored in the database. I have tried many things like mysql_real_escape_string() and encodeURI but nothing solve the problem. What can I [...]
