Mysql - Revision history

Dre at 01:22, 1 May 2007

2007-05-01T01:22:33Z

Dre at 00:43, 19 August 2005

2005-08-19T00:43:13Z

Dre at 01:13, 18 April 2005

2005-04-18T01:13:29Z

Dre at 01:09, 18 April 2005

2005-04-18T01:09:04Z

Dre at 01:07, 18 April 2005

2005-04-18T01:07:59Z

Dre: initial rev

2005-04-18T01:04:39Z

initial rev

New page

'''Connect to a db host:'''
mysql -u user -h db.host.com -p

'''List databases''':
show databases;

'''Move into a db and list tables''':
user foo;
show tables;

'''Examine data:'''
DESCRIBE wiki_user;
select user_name from wiki_user;
select user_id, user_name, user_real_name, user_email from wiki_user;
select * from wiki_user where user_name = "Dre";

'''List all user-contributed wiki stories''' (in this wiki, cur_id of user contrib'd pages starts at 928)
select cur_title from wiki_cur where cur_id > 927;

'''Show text of an entry'''
select cur_title, cur_text from wiki_cur where cur_id = 930;

@@ Line 21: / Line 21: @@
 '''Show text of an entry'''
   select cur_title, cur_text from wiki_cur where cur_id = 930;
 '''Backup / Restore'''
   mysqldump -u user -h db.host.com -p database > dump.sql
   mysql -u user -h db.host.com -p database < backup-file.sql

← Older revision		Revision as of 01:13, 18 April 2005
Line 20:		Line 20:
	'''Show text of an entry'''		'''Show text of an entry'''
	select cur_title, cur_text from wiki_cur where cur_id = 930;		select cur_title, cur_text from wiki_cur where cur_id = 930;
		+
		+	'''Backup / Restore'''
		+	mysqldump -u user -h db.host.com -p database > dump.sql
		+	mysql -u user -h db.host.com -p database < backup-file.sql

@@ Line 14: / Line 14: @@
   select user_id, user_name, user_real_name, user_email from wiki_user;
   select * from wiki_user where user_name = "Dre";
 '''List all user-contributed wiki stories''' (in this wiki, cur_id of user contrib'd pages starts at 928)

@@ Line 6: / Line 6: @@
 '''Move into a db and list tables''':
-  user foo;
+  use foo;
   show tables;