Server :: MySQL - Add An ENUM Value Later?
May 8, 2011
I create a MySQL table with a ENUM column with the possible values BOOK, DVD, and CASSETTE. And then two years later I decide I want to add another possible value (say, ISOLINEAR CHIP :-). This won't be a problem, right? I got the impression from an on-line post that I could use ALTER TABLE to do this and it wouldn't be a problem. But I wanted to get a second opinion because obviously I don't want to come back two years later and run into some major issue.
View 1 Replies
ADVERTISEMENT
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
May 13, 2010
Code:
DWORD type = REG_NONE;
int i = 0;
[code]....
View 14 Replies
View Related
Jul 29, 2010
I've got an enum in the global scope in my file.c. If I try to reference that enum in a function, I get an error:
Code:
// declared in the public scope:
public enum AMFFlags { AMF_AMF3 = 1<<0, AMF_BIGENDIAN=1<<1,AMF_ASSOC=1<<2,AMF_POST_DECODE = 1<<3,AMF_AS_STRING_BUILDER = 1<<4, AMF_TRANSLATE_CHARSET = 1<<5,AMF_TRANSLATE_CHARSET_FAST = 1<<5|1<<6};
// the function, declared via macro:
PHP_MINIT_FUNCTION(amf)
[Code]...
View 3 Replies
View Related
Jun 18, 2011
the compiler (g++ 4.4.5) does not recognize PRE as a type in the following code:
Code:
enum mode {PRE, IN, POST};
class tree
[code]...
View 9 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
Jan 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 3, 2009
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 3 Replies
View Related
Apr 21, 2011
I'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
View 2 Replies
View Related
Sep 29, 2010
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
View 3 Replies
View Related
Mar 28, 2010
Im getting this error when i try to run mysql from a shell
Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket
I have installed MySQL over yum on fedora.
but the path and file /var/lib/mysql/mysql.sock does not exist on my system?
View 3 Replies
View Related
Apr 11, 2010
I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:
Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server
[code].....
View 3 Replies
View Related
Feb 3, 2011
We have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.
View 2 Replies
View Related
Aug 25, 2010
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 Replies
View Related
Oct 4, 2010
I have a RHEL5 machine having mysql5.0.22 is installed in it. i also installed java through "jdk-1_5_0_19-linux-i586.bin" package, and its version is 1.5.0_19. I am trying to check if any JDBC driver for Mysql Server is installed on my system . How can I do this? If any driver is already installed How can I get the file path for those driver files? is it comes along with jdk packages? As i am not a programmer, and does't know more about jdbc.
View 1 Replies
View Related
Nov 19, 2010
I tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
View 6 Replies
View Related
Apr 24, 2011
I have an e-mail production server that has been running fine for almost two years.
Notice mail was not serving today and login to a bunch of errors in messages
However, I think they are all from not being able to access MySQL and when I:
mysql -u root -p
I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
View 5 Replies
View Related
Jun 16, 2010
what the difference is between msql-server and mysql-community-server
View 5 Replies
View Related
Mar 2, 2010
I've just made my old, dusty computer into an Ubuntu Server. So far, i have installed a well functioned LAMP server, to host my Website. I have also installed a FTP-Server (proftpd) and i was wondering if i could manage my FTP accounts in MySQL so i could make an account creation page for it? If yes, how?
View 2 Replies
View Related
Apr 20, 2010
I like to run a mySql database server on a Ubuntu (which is no server) for local use only. Is there some instruction how to do this? I downloaded several DBMS but they all seem to assume a running server.
View 1 Replies
View Related
