Changing MySQL.cnf
I want to change the values of query_cache and key_buffer in Mysql.cnf. Do I need to restart the dDb or is there a way to change this dynamically?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Changing Mysql On New Host
A friend of mine set up a mySql database for me a while ago and i have been maintaining what he built for some time. Due to issues with bandwidth i have had to transfer web hosts. So i need to transfer what i have into the new panal. Sounds easy - as i say im a complete novice and am struggling. My new host have given me new passwords for my mySql database and i have an SQL dump of my old database. I am starting completely from the absolute beginning on the new database and using things for the very first time. What do i do?
View Replies !
View Related
Changing MySQL Password
I am trying to learn MySQL and I don't have a clue what my username and password is. I am on win98. I had installed MySQL awhile back and tried re-installing it, but it skips the password / username part. I assume there must be a file I can change in notepad.
View Replies !
View Related
Mysql Changing Value Of My Decimal
this is really weird. I tried it on both windows and linux with the same problem. Basically, I have a float(10,2) field, and if I enter a big number with decimal of .01 the decimal gets rounded to .02 example: 222333.01 becomes 222333.02 My database is mysql 4.1.2 here is a dump of my test database: CREATE TABLE `tblpayroll` ( `payenddate` date NOT NULL default ��-00-00', `principal_id` int(100) unsigned NOT NULL default Ɔ', `vessel_id` int(100) unsigned NOT NULL default Ɔ', `vessel_allotment` float(8,2) NOT NULL default Ɔ.00', `vessel_pesoval` float(10,2) NOT NULL default Ɔ.00', `amt1dollar` float(8,2) NOT NULL default Ɔ.00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblpayroll` -- INSERT INTO `tblpayroll` (`payenddate`, `principal_id`, `vessel_id`, `vessel_allotment`, `vessel_pesoval`, `amt1dollar`) VALUES (��-00-00', 1, 1, 222333.01, 0.00, 0.00); any thoughts??
View Replies !
View Related
Changing Forgotten MySQL Root Password
I get an error like this when trying to fix the password with safe mode and mysqladmin: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' Here is what I have done so far: Command: mysqladmin -u root -p <oldpw> password <newpw> Outcome: mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' I have performed everything in the MySQL Manual section A.4.1 How to Reset the Root Password. Same outcome same error. I dont get it. What is going on. I have researched this for about 6 hours now with no luck. Finally going to see what the "experts" have to say.
View Replies !
View Related
Changing Servers With Lower Mysql Version
I am trying to change servers and the new server is hosting a lower version of mysql therefore giving me errors when trying to import db. The dbs are for postnuke and here's the error I am getting: Error > SQL query: > > -- phpMyAdmin SQL Dump > -- version 2.8.2.4 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Oct 04, 2006 at 12:33 PM > -- Server version: 4.1.21 > -- PHP Version: 4.4.2 > -- > -- Database: `betweent_business` > -- > CREATE DATABASE `betweent_business` DEFAULT CHARACTER SET latin1 COLLATE > latin1_swedish_ci; > > > > MySQL said: > > #1064 - You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line > > I know a little about mysql, but not enough to mess with this... > > New version: MySQL - 4.0.27-standard > phpMyAdmin - 2.8.0.2 > > My old version: MySQL - 4.1.21-standard > phpMyAdmin - 2.8.2.4
View Replies !
View Related
Changing Existing Mysql Account Usernames
The situation I have is, I have an existing MySQL user account, lets say its called "myacct". What I want to do is change "myacct" to "testacct", leaving all the account privileges intact. From looking at the database I thought I would be able to accomplish this by issuing UPDATE commands on mysql.db, mysql.tables_priv, and mysql.user to change all occurrences of "myacct" to "testacct" but this gives me some weird problems when I try to access the database using "testacct".
View Replies !
View Related
Changing NOW()
Is it possible to change NOW() to a different time zone? Reason why I need this is my server is in America and I live in Australia, I know how to do it though php but I would have to use the date function, just thought I would check to see if it is possible to do it in mysql before starting on the php way.
View Replies !
View Related
Changing Max
I'm using MySQL server, community edition 5.0.18-nt installed on localhost. I'm using the Dot Net connector drivers on client side within a Dotnet application. I am migrating selected parts of my Microsoft SQL Server database to mysql. One of the tables is my images table which contains BLOB fields that may be quite large. While trying to import records to this table, I receive the error "Unable to write to stream". A google search revealed the following page http://forums.mysql.com/read.php?38,47230,47230 I fixed it with "set global max_allowed_packet=268435456;" How can i view what the current max_allowed_packet size is? At some time in the near future we'll be using a MySQL server version of our database in the field. It's very very likely that I'll completely forget that this value needs changing when MySQL is installed on client machines. If this value CAN be set in an option file that I can add to an install, which one is it please?.
View Replies !
View Related
Changing .cnf
I have been advised by a tech to change the my.cnf settings. Do I have to stop mysql before I change the .cnf file? Or can I change the config settings and then restart it... How do I stop mysql? How do I restart mysql? Code:
View Replies !
View Related
Changing Privileges
I need help changing host privileges in mySQL server. I am trying to access mySQL server from a remote computer that doesn't have access rights. The online doc sucks; I can't get anything useful out of it.
View Replies !
View Related
Changing DATADIR
I installed MySql with the default settings. But I'd like now to change the place where I keep my data files. I tried changing the DATADIR parameter in /etc/my.cfg but the server won't start. Is there any way to change only the data directory from /var/lib/mysql to /otherplace/mysql and leave everything else in it's place?
View Replies !
View Related
Changing A Default Value
i have a column that originally assigned a default integer value (1) to a column that contains about 1000 records. now, i'd like to replace all those with an incremented value. i figured out how to change it so newly added data is incremented, but cant seem to figure out the command to go back and change all data from the beginning so that it is now incremented.
View Replies !
View Related
Changing Charset
Is there a way to globally overwride the charset in tables? Somehow I got latin-1 from phpmyadmin. Otherwise I'll loop through the tables and fields and change them all using varchar type.
View Replies !
View Related
Changing Column
How can I create a query that will take values in columns and give me them as additional rows instead? For example, I need to query a table like this: id, A, B, C 1, 11, 12, 13 2, 14, 15, 16 3, 17, 18, 19 ... and get a result like this: id, label, value 1, A, 11 2, B, 12 3, C, 13 4, A, 14 5, B, 15 6, C, 16 7, A, 17 8, B, 18 9, C, 19 Anyone know how to do this?
View Replies !
View Related
Changing Datatype
I have a table - lets call it "TABLE". I have a column in TABLE called "COUNT", which has a datatype of "TEXT". currently, TABLE is heavily populated with records. Column COUNT is populated with Integers. I want to change the datatype of COUNT to "BIGINT" w/o losing any of the data.
View Replies !
View Related
Changing Date
I have a table 'test' that has the date in a varchar field formatted like this: 12/05/83. I need to switch the date to this: 1983-12-05. This is what I have so far: UPDATE test SET dateEntry = CONCAT( '19' , SUBSTRING_INDEX(dateEntry, '/', -1), '-', SUBSTRING_INDEX(dateEntry, '/', 2) ) which gives me: 1983-12/05. I can't figure out how to change the / to a - Is this a two-step conversion or is there a way to do it in one UPDATE statement?
View Replies !
View Related
Changing The Value In A Specific Row
i have a forum that i am trying to add a username kind of thing to. what i have done so far is to set up a table that has three coloumns in it, USERNAME, PASSWORD, and STAT, of which stat is a boolean value that i use to determine if they are logged in or not (what i intend for it to be), and the other two are pretty self explanatory. my question is is there a way for me to get into this specific row and change the value stored inside STAT, or is my only choice to completely delete this row then re-enter it into the table everytime stat has to change? thanks guys. btw good forum you have here
View Replies !
View Related
Changing A Substring
i need some help with a sql query that will replace a string in a bunch of fields. for example the select that shows the fields is which need changing is "SELECT link FROM links WHERE like LIKE '%ID123%'" i want to change all of the 'ID123' occurances to a different string. the urls are all different but the 'ID123' part is the same in all of them. so keep the url but change the ID123 but how can i do this?
View Replies !
View Related
Index: Changing The Name
Is there an easy way to change the name of an index, without having to drop it and create a new one? I know how to find the index name in the information_schema.statistics table, but these seems more reflective. If I were to change the name here, that doesn't really change the name of the index, does it? Is there a SQL statement to change the name of an index from one name to another?
View Replies !
View Related
Results Keep Changing
I have a site which lists the top 3 best pay sites. Yesterday when i checked the top 3's (there are 3 of them) i copy-pasted them in a document. After pressing refresh multiple times it stayed the same. However the next day when i checked the results had changed and no new votes had taken place. This is my code: SELECT service, count(service) voteQty, AVG(rating) AS rating FROM rate WHERE type = 'pt' GROUP BY service ORDER BY rating DESC, voteQty DESC LIMIT 3 thats for one of the 3 top 3's the other 2 are almost the same. Why do my results keep changing?
View Replies !
View Related
Dates Not Changing
I know mySQL is supposed to accept years up to like 9999 or something. I have a variable thats stored as a DATE. The problem is if you enter a date in the future, it resets the value to 0000-00-00 but if I put in todays date or an earlier date it does not change it. Why?
View Replies !
View Related
Changing A NULL Value
First time posting and I'm a little stuck - the following code returns all the values I want where the column "ViewID" is NULL. SELECT * FROM ceta.resource r LEFT OUTER JOIN ceta.resourceview rv ON r.resourceID=rv.resourceID WHERE viewID IS NULL; However, I'm looking to replace these NULL values with another value eg: 1041 I've tried the following: SELECT * FROM ceta.resource r LEFT OUTER JOIN ceta.resourceview rv ON r.resourceID=rv.resourceID WHERE viewID IS NULL SET viewID IN NULL = '1041';
View Replies !
View Related
Changing The Backslash
I would like to disable the backslash behavior to all my SQL strings. For sample: UPDATE USER SET DEFAULT_FOLDER = 'C:TEMP' (desirable) instead UPDATE USER SET DEFAULT_FOLDER = 'C:TEMP' (not desirable) I would like to treat special characters like in MSSQL, because all modules of my program use that. I'm doing a migration work
View Replies !
View Related
Changing Username
I went to mysqladmin -u root password and changed to other username, e.g. daniel. Now it is daniel without password. Can I change it back to root for some reasons I suspect that my wamp phpmyadmin doesn't allow me privilige access. I tried using the method I used to change it but can't.
View Replies !
View Related
Changing Platforms
Our company has been running MySQL 4.1 under MacOSX for about 3 years, hosting 6 InnoDB databases (semi-large, around 65GB total). The performance of the PowerPC Xserve is starting to slow us down, and we have just purchased a new server. However it will be an Intel / Windows based server. We run 'mysqldumps' every night and I have restored them them to other OSX servers in the past. However now that its getting closer to production time, I've stumbled accross some "Case Sensitivity" questions about Windows. If I understand correctly MacOSX (10.4) defaults to "lower_case_table_names=2" The MacOSX file-system is NOT case-sensitive but the table names are created that way, but NOT actually stored/retrieved that way. When I do a 'show tables;' they are definitely 'Mixed Case'. Also, I believe Windows defaults to "lowers_case_names=1", and the filesystem is NOT case-sensitive, and the tables are NOT case-sensitive. On to the point.... When I restore the dumps onto Windows the tablenames become all lowercase. This could be a potential problem, as I'm not sure how the software we use references the tables. If I set lower_case_names=2 on windows and restore the mysqldumps, the table-names have the same 'Mixed Case' as they do on the mac ( show tables; ).
View Replies !
View Related
About Changing Password
I ran; mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'oldpassword'; creating password Now I need changing its password whether to run; mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user="'mail_admin'@'localhost'"; Then where to put mail.* ? It is NOT a database.
View Replies !
View Related
Changing Date_format
Using the following syntax i can add date in YYYY-MM-DD format. INSERT INTO news_table (s_time,text_sub) VALUES (current_date(),'text'); Question: How can i change the format to DD-MM-YYYY? INSERT INTO news_table (s_time,text_sub) VALUES (DATE_FORMAT(current_date(),%d %M %Y),'text') -- got error...
View Replies !
View Related
Changing Column &
I want to change one of my colums from a date type to a varchar how can i do this. i assume i use the update line! Example: UPDATE table name SET column name = 'insert change here' WHERE modifier = 'insert modifier specific here' But obviously that won't quite work! If someone coudl let me know the actual line i need i'd apreciate it!
View Replies !
View Related
Changing Values From 0 To 1
I would like to change ONLY the 0 values to 1 on a nuke_users table, row user_level. This command will change all values (UPDATE nuke_users SET user_level = 1 WHERE 1;) but I only want to change the (zero) values to 1 (one) and keep the other values as -1, 3, etc.
View Replies !
View Related
Clause Changing
What is a difference between? SELECT Sect.* FROM {{LongExpression}} WHERE (1=1 or NULL) GROUP BY Sect.ID; and SELECT Sect.* FROM {{LongExpression}} WHERE (1=1) GROUP BY Sect.ID; {{LongExpression}} == Section Sect LEFT JOIN A ON A.Section=Sect.ID LEFT JOIN Br B ON B.AID=A.ID LEFT JOIN Permission Perm ON Perm.BrID=B.ID LEFT JOIN map S ON S.ID=Sect.SystemID LEFT JOIN Un U ON (B.ID=U.T AND U.User=1) In the first case I get no row at all, whereas in the second case, I get 8 (the expected amount).
View Replies !
View Related
Changing The Timezone
Ok, right now im setting up a news script where it has the title, post, userid, and date. Now I have it set up to select the date and format it so it shows 02-21-2005 05:25:00 PM. Now for each user, I set up a timezone offset, so they can change what the date/time reads. Right now I have this as a MySQL command: SELECT DATE_FORMAT(post_date, '%m-%d-%Y %h:%i:%s %p') AS post_date, Can anyone help me to get that auto changed to like a EST timezone (-5) or something. I want to make the script user friendly to people of all areas around the world.
View Replies !
View Related
Changing The Ordering
Sadly, this isn't one that can be answered simply by changing ORDER BY field DESC to ORDER BY field ASC. What I need to do is to be able to display a list of items in an arbitrary order that can be changed, e.g., A B C D might need to change to C B D A I'm thinking that the best way to approach this would be to add another column sort_order that contains integer values which could then be used in an ORDER BY clause on my SELECT statements. Anyone else have any better ideas? I've done it this way before and it does work, I'm just wonder if there's some utterly brilliant solution out there that doesn't require additional metadata.
View Replies !
View Related
Changing Value After 30 Seconds?
Is there a way to change a value after 30 seconds of it being changed? So if I change it to 1 from an external script, I want to 30 seconds later to change to 0. Is this possible without a script (or a script in sql of some sort?)?
View Replies !
View Related
Changing A Query To Use BETWEEN?
I'm trying to convert my SQL query so I can only show the results which are between a from date and a to date? Heres the original... SELECT Approve, ID, Name FROM PROVIDER WHERE Approve = Ƈ' ORDER BY ID ASC LIMIT $from, $max_results Heres what I want to do.. SELECT Approve, ID, Name, From, To FROM PROVIDER WHERE Availibility BETWEEN From AND To AND Approve = Ƈ' ORDER BY ID ASC LIMIT $from, $max_results
View Replies !
View Related
Changing Column Name To New Col Name
I looked up the MySQL for altering a column name and came up with the following -- ALTER TABLE PartnoLinkCat_assoc CHANGE 110684 PartNo NOT NULL; 110684 = old col name PartNo = new col name However, phpMyAdmin gives me a 1064 error. I don't know what I'm doing wrong.
View Replies !
View Related
Changing My Variables
I'm really nubbin at this and just recently starting looking at MSQL database things. The main question is can I change the Variables of my database? Its a MySQL database...at I want to change query_cache_limit = 1,048,576 to 62 million or whatever, also have a bunch of other values I want to change.
View Replies !
View Related
|
TRACKER
