Update of /cvsroot/phpwebapp/web_app/boxes/webnotes/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1019/boxes/webnotes/db
Added Files:
webnotes.sql dump.sh
Log Message:
The webbox 'webnotes' can be used to append comments or notes
to documentation pages or to other web pages.
--- NEW FILE: webnotes.sql ---
-- MySQL dump 8.23
--
-- Host: localhost Database: webnotes
---------------------------------------------------------
-- Server version 3.23.58
--
-- Current Database: webnotes
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ webnotes;
USE webnotes;
--
-- Table structure for table `webnotes`
--
CREATE TABLE webnotes (
note_id int(10) unsigned NOT NULL auto_increment,
page_id varchar(255) NOT NULL default '',
email varchar(100) default '',
ip varchar(100) default '',
date_modified datetime default '0000-00-00 00:00:00',
status varchar(100) default '',
note_text text,
PRIMARY KEY (note_id)
) TYPE=MyISAM;
--- NEW FILE: dump.sh ---
#!/bin/bash
### modify them as appropriate
host=localhost
user=inima
dbname=webnotes
### dump the database $dbname into the file webnotes_backup.sql
mysqldump --add-drop-table --allow-keyword \
--complete-insert --extended-insert \
--compress --host=$host --user=$user -p \
--result-file=webnotes_backup.sql --databases $dbname
### dump the structure of the database as well
mysqldump --allow-keyword --no-data \
--host=$host --user=$user -p \
--result-file=webnotes.sql --databases $dbname
### create the database with the command:
### $ mysql -p -u $user < webnotes.sql
###
### restore the database with the command:
### $ mysql -p -u $user < webnotes_backup.sql
|
