mysql

Database page corruption on disk or a failed

Posted by bower on January 04, 2011
linux/ubuntu, mysql / No Comments

see 分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

source site Database page corruption on disk or a failed

binaire opties heineken mysql 无法启动, 提示 page corruption

http://hivtestkit.ph/?melisa=rencontre-madagascar-tamatave&b3d=b2 ubuntu 下mysql的log 日志在/var/log/syslog

source link Continue reading…

MySQL 10061错误 远程连接拒绝

Posted by bower on April 02, 2010
mysql / No Comments

agence rencontre reims 分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

follow MySQL 设置远程访问的方法  http://www.bowerpower.cn/archives/405

https://distillery244.com/frnew1/8911 结果报错10061

rencontrez l'europe 研究发现少做一项工作

site de rencontre amicale sans inscription Continue reading…

http://fcl-feytiat.fr/?sdrer=demeter-recherche-sa-fille-disparue&5d3=3c Tags:

ubuntu trac 基于使用 mysql svn

Posted by bower on March 30, 2010
mysql, ubuntu server / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

go to site 在Ubuntu下安装Trac十分简单,只需要输入下列命令即可:
sudo apt-get install trac Continue reading…

mysql导出所有全部数据库,多个数据库一起导入

Posted by bower on September 08, 2009
linux/ubuntu, mysql / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

想把centos适移到ubuntu 把整个mysql移动,就是导入和导出
[root@localhost opt]# mysqldump -u root -p –all-databases > dump.sql
[root@localhost opt]# ssh yourhost
[root@localhost opt]# mysql -u root -p < dump.sql Continue reading…

如何用MySQL-Front远程连接MySql

Posted by bower on September 04, 2009
mysql / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

1。改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 “mysql” 数据库里的 “user” 表里的 “host” 项,从”localhost”改称”%”

Continue reading…

MYSQL DELETE语法

Posted by bower on August 10, 2009
mysql / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

单表语法:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_definition]
[ORDER BY …]
[LIMIT row_count]
多表语法:

Continue reading…

Tags:

mysql 更改表的主键为auto_increment

Posted by bower on August 06, 2009
mysql / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

change the primary key for a table in mysql

创建:
mysql> create table ref (ref_id int unsigned not null, something varchar(30), primary key(ref_id));
更改:
mysql>alter table ref drop primary key , add column newcol int auto_increment PRIMARY KEY ;

mysql导入.sql文件

Posted by bower on June 03, 2009
mysql / No Comments

分享给你的朋友->bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

[root@localhost]:mysql -r -p

mysql> user yourdb;

mysql>  source pathfilel.sql;
source后跟sql文件全路径
搞定

Tags: