Openfire is a very good IM server, and it is implemented in pure Java and has multiple platform versions. Its data storage can use a variety of databases, such as MySQL and Oracle.
In actual use, the most common problem encountered is the garbled
the data tables have been created. If we have inserted a lot of data, we can search and display the information in the data table in our favorite way, for example: the entire data table content can be displayed as follows select * from President;
Finally, let the server back up the MySQL database every morning and automatically package it, and delete the backup files five days ago. Share as follows:
1. Environment: Windows Server 2003 + Apache 2.0 + PhP5 + MySQL 4.0.26.
2. Assume that
If you use the MySQL database and use the dbgo (ADO) component to connect through MySQL ODBC 3.5.1 or MySQL connector/ODBC 5.0, then your tadoconnection connection string (connectionstring)
1. when accessing the local database:
'Driver = {MySQL
How to download and install the MySQL database:
: Http://dev.mysql.com/downloads/. download the package and install it in double steps.
========================================================== ===== How to configure the MySQL database:
Install, uninstall MySQL service install MySQL service create and edit a BAT file, execute it (E: \ mysql \ bin \ mysqld-nt.exe is the installation directory, fill in according to the actual situation) @ echo off E: \ mysql \ bin \
The output result of the processlist command shows which threads are running. This command can be used to identify problematic query statements.
1. Enter mysqladmin processlist In the MySQL/bin directory;
2. Start MySQL and enter show
For operations on the string position, the first position is marked as 1.
ASCII(str)
Returns a string.strASCII code value of the leftmost character.If
strIs a null string and returns
0. If
strYes
NULL, Return
NULL.
mysql>
Document directory
15.2.1 log on to and exit the MySQL server
15.2.2. New common users
15.2.3 Delete common users
15.2.4. the root user changes his/her password.
15.2.5. change the password of a common user as the root user.
15.2.6. change
Xmiserver_v2.5.20.beta ASP + CGI + PHP + JSP + MySQL All-Around server suite released!
2009.03.20 //46 comments
Xmiserver_v2.5.20.beta ASP + CGI + PHP + JSP + MySQL All-Around server suite released!
Software name: xmiserver_v2.5.20.betaSoftware
Applicable scenarios of Pt-stalk: ① MySQL server performance fluctuations FrequencyVery low, for example, once a few days ② MySQL server performance fluctuations ProbabilitySoon, for example, flash in a few seconds (I) Installation ① Download
Before making the benchmark test design better, you must first check which common errors should be avoided, which may result in useless or inaccurate test results.
Use is a subset of data, rather than a complete set. For example, an application
MySQL changes User Permissions
This entry was posted by admin Monday, 26 then l, 2010
1. "grant all on *. * to root @ '%' identified by 'yourpassword';" -- the password can also be set along with the password.2. "Flush privileges;" -- refresh to
How can I not connect to MySQL on this server when I configure a server today. Remote logon is normal, and access to MySQL on this machine is normal. Error prompt SQLError (2003): Can't connect to MySQL server on '**' (IP) (10061) (** at that time,
Export data table structure
Mysqldump-D-uroot-P superadmin> D:/superadmin. SQL
Allow MySQL to access a machine
Grant all on *. * to root @ "192.168.1.1" identified by "19870806 ";
Flush privileges;
Backup and disaster tolerance are often encountered
Original article: http://lxh71105321.blog.163.com/blog/static/23988844200901394611940 /#
For a long time, I have been wondering why mysql Data insertion slows down when I use the MYISAM engine. I am puzzled
Myisam does not support transactions.
1,Transaction ProcessingInnodb supports the transaction function, which is not supported by myisam. Myisam is faster and has better performance.
2, select, Update, insert, delete operationsMyISAM: If you execute a large number of SELECT statements,
When I was learning new technologies, it was really depressing to configure the environment. But fortunately, many of my friends on the Internet are very helpful to me.
1. install and configure APACHE (install it to D: \ phpapache \ Apache2.2)1. It
In MySQL, The While statement loop is different from that in SQL Server, and the code passes the test.
In MSSQL, The while statement is used to generate data cyclically:
Sample Code:Copy codeThe Code is as follows: declare @ a intSet @ a =
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service