Webmaster2020.com

You probably set default-character-set=utf8 Under [client] in /etc/mysql/my.cnf You also need to set it under [mysqld] ; Actually character-set-server=utf8 would be better. This should take care of the Server characterset . For your database you have to do some additional steps. in MySQL give the fo...

You can use TININT(1) to set a value of 1 bit (0 or 1).

But my personal favorite is EMNUM note: ENUM can have more then 2 values, up to 65,535.

There is a nice solution in MySQL. Add the keyword SQL_CALC_FOUND_ROWS right after the keyword SELECT : SELECT SQL_CALC_FOUND_ROWS table1.id, table2.name,table3.name FROM table1, table2, table3 WHERE (associate table1, table2 and table3 to each other) GROUP BY table1.id LIMIT 10,20 After that, run a...

This is set by datadir in my.cf (/etc/mysql/my.cnf) in Linux,
or my.ini (C:\Program Files\MySQL\MySQL Server 5.1\my.ini) in Windows

Standard it is in Linux:
datadir = /var/lib/mysql

in Windows:
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

This is set by datadir in my.cf (/etc/mysql/my.cnf) in Linux,
or my.ini (C:\Program Files\MySQL\MySQL Server 5.1\my.ini) in Windows

Standard it is in Linux:
datadir = /var/lib/mysql

in Windows:
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

You can add a 4th parameter in mysql_connect, this will open a new separated connection. $dbconn1 = mysql_connect($hostname, $username, $password); $dconn2 = mysql_connect($hostname, $username, $password, true); mysql_select_db('database1', $dbconn1); mysql_select_db('database2', $dbconn2); $result1...

you can use max-width in css. for example you can use the following class: .bigtable{max-width:1024px;valign:top;margin-left: auto;margin-right: auto} max-width:1024px : The maximum size of your table will be 1024 pixels. valign:top : position of the table margin-left: auto;margin-right: auto : it c...

You can use update-rc.d The remove will completely remove the startup files,
you don't want that. Hope this is what you are looking for.

Usually it means there are still some settings wrong with your apache configuration. Make sure all the port is set : Listen 10443 But also NameVirtualHost *:10443 and <VirtualHost *:10443> you can find the settings in /etc/apache2/httpd.conf or for virtual hosts /etc/apache2/vhosts.d/0x_yoursite.con...

You can do this with the builtin chkconfig utility: sudo /sbin/chkconfig --list This command show you all the services and their status on each runlevel. If you don't see your service in it (mysqld for example?), you can add it. sudo /sbin/chkconfig --add mysqld You also need to set it to ON, in the...