Category: mysql

mysql

enable mysql Query cache

How to enable mysql Query cache on linux server? Ans: You need to login to mysql by using root accesss. ========================== root@server#mysql -u root –pPASSWORD mysql> SET GLOBAL query_cache_size = 16777216;              (If you want to set query_cache_size=16 MB) ========================== Then...

mysql

mysqldump: Got error

Error : When you try to run the mysqldump command to make a backup of database then encounter the following error-exception:mysqldump databasename  > databasename.sqlmysqldump: Got error: 1016: Can't open file: './databasename/wp_142_term_taxonomy.frm' (errno: 24) when using LOCK TABLESSolution: Open the file...

Email Marketing Series, How to, mysql, Tomcat

mysql connection in jsp

Database Connection by using jsp page . The URL based mysql connection  is ================================= jdbc:mysql://serverip address/DATABASENAME?user=USERNAME&password=PASSWORD ================================= OR ================================= <!-- Database connection settings --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost/database_name</property> <property name="connection.username">databses_user</property> <property name="connection.password">password</property> <!-- configuration pool via c3p0--> ================================= OR =================================...