MySQL数据库备份与恢复 

方法一:

1.导出整个数据库

命令行进入到mysql安装目录的bin目录下

假设装在D:/mysql/bin

即:开始 运行 输入cmd

d:

cd mysql/bin

然后执行下面语句


mysqldump -u 用户名 -p 数据库名 > 导出的文件名  


示例:mysqldump -u root -p sq_wcnc > d:\wcnc.sql

一、  配置环境:


RedHat 8.0


jdk安装路径:   /usr/jdk1.4.2


tomcat安装路径:/root/Tomcat5.0/


mysql安装路径: /usr/local/mysql


总共分为以下几个步骤:

1、安装配置jdk1.4.2

2、安装配置Tomcat5.0和测试

3、安装mysql和测试


所需要的软件:                       下载地址


jdk: j2sdk-1_4_2_05-linux-i586-rpm.bin         http://java.sun.com/j2se/1.4.2/download.html


tomcat: jakarta-tomcat-5.0.27.tar.gz                  http://www.apache.org


mysql: mysql-standard-5.0.0-alpha-pc-linux-i686.tar.gz  http://www.mysql.com


这些软件全部在/usr/download留个备份


1. 安装配置jdk

下载其中的rpm包,其实是个.bin文件

#chmod u+x j2sdk-1_4_2_05-linux-i586-rpm.bin       //设置包的属性

#./j2sdk-1_4_2_05-linux-i586-rpm.bin              //看协议并解成rpm包(不断的按回车键)

#rpm -ivh j2sdk-1_4_2_05-linux-i586-rpm           //进行安装

#cd /usr                                          //进入安装好的目录

#ln -s j2sdk1.4.2_05 jdk1.4.2                     //做个jdk1.4.2的目录连接到j2sdk.1.4.2_05


设置环境变量:


写到/etc/profile中, 那样系统启动时会自动加载jdk, 打开文件/etc/profile, 并将以下语句写入:


export JAVA_HOME="/usr/jdk1.4.2"


export PATH="$PATH:$JAVA_HOME/bin"


export CLASSPATH="$JAVA_HOME/lib"


export CATALINA_HOME="/root/Tomcat5.0"


2. 配置tomcat 


#cd /root


#tar zxvf jakarta-tomcat-5.0.27.tar.gz        //解包


#ln -s jakarta-tomcat-5.0.27  Tomcat5.0       //做个tomcat的目录连接到jakarta-tomcat-5.0.27


测试Tomcat能否正常启动:


启动Tomcat:


# cd /root/Tomcat5.0


# bin/startup.sh


关闭Tomcat:


# cd /root/Tomcat5.0


#bin/shutdown.sh


若看到以下信息:

Using CATALINA_BASE:      /root/Tomcat5.0

Using CATALINA_HOME:     /root/Tomcat5.0

Using CATALINA_TMPDIR:  /root/Tomcat5.0/temp

Using JAVA_HOME:            /usr/jdk1.4.2


证明Tomcat5.0配置OK了!


适当修改一个/root/Tomcat5.0/conf目录下的server.xml文件,


将port=8080改为80


<Host name="192.168.1.191" debug="0" appBase="euw3" unpackWARs="true" autoDeploy="true"


xmlValidation="false" xmlNamespaceAware="false"> 其中host name为Linux主机的IP地址!


然后打开浏览器,输入http://192.168.1.191,如果您能看到一只变态的小猫望着你的话,那么恭喜您,tomcat也成了!


3. 安装mysql


安装二进制版本:mysql-standard-5.0.0-alpha-pc-linux-i686.tar.gz,假设其放在/usr/down目录下


必须成为root用户,然后解压到 /usr/local目录,操作步骤如下:


# cd /usr/local


# su


# tar –zxvf  /usr/down / mysql-standard-5.0.0-alpha-pc-linux-i686.tar.gz


在所有文件解压完后,一个名字叫mysql-standard-5.0.0-alpha-pc-linux-i686的目录将被创建出来。我们为这个目录做个符号链接,并给它一个更友好的名字mysql (免得叫mysql-3.22.21-pc-linux-gnu-i686这么长):


# ln -s mysql-standard-5.0.0-alpha-pc-linux-i686 mysql


首先将MySQL目录和文件的拥有权改成 mysql 用户和root组:


# cd /usr/local

# chown -R mysql:root mysql-standard-5.0.0-alpha-pc-linux-i686 mysql


然后运行一个小脚本程序,以建立初始化的MySQL数据库。请以一个mysql 用户的身份完成这个任务,这也是我们能够直接使用这个帐户的唯一机会。


# su mysql


$ cd mysql


$ scripts/mysql_install_db


$ exit


让Linux开机自动运行MySQL


在/usr/local/mysql/support-files中有一个叫mysql.server的启动脚本程序, 把它复制到/etc/rc.d/init.d目录里面:


# cd /etc/rc.d/init.d

# cp /usr/local/mysql/support-files/mysql.server mysql


接着把它的属性改为“x”(executable,可执行)


# chmod +x mysql


最后,运行chkconfig把MySQL添加到你系统的启动服务组里面去。


 


 


# /sbin/chkconfig --del mysql


# /sbin/chkconfig --add mysql


测试MySQL


现在可以将我们项目的数据库euw3复制到/usr/local/mysql/data下


首先启动MySQL:


# cd /usr/local/mysql


# /etc/rc.d/init.d/mysql start(因为我们已经让mysql服务自动启动,此步可以省略)


关闭MySQL:


# cd /usr/local/mysql


#bin/mysqladmin –u root –p shutdown (若用户名为root时,一般没有设密码)


#cd /usr/local/mysql


#bin/mysql


如果一切正常,你将看到屏幕显示出以下信息:


Welcome to the MySQL monitor. Commands end with ; or \g.


Your MySQL connection id is 2 to server version: 5.0.0


Type 'help' for help.


mysql>


接着,用show databases命令可以将安装的数据库列出来:


mysql> show databases; (注意要加;)


你就可以看到:


+----------+


| Database |


+----------+


| euw3 |


| mysql |


| test


+----------+


3 rows in set (0.00 sec)


如果一切正常的话,那说明MySQL可以完全工作了! 恭喜你!如果要退出程序,输入:exit


mysql> exit;


Bye


更改管理员密码:


#cd /usr/local/mysql


#bin/mysqladmin –u root password newpassword


让mysql数据库支持utf-8编码:


/usr/local/mysq/support-files/my-medium.cnf复制一份,改名为my.cnf,将其放在/etc目录下(此文件相当于windows中的.ini文件)


在[mysqld]项目下,加入一句default-character-set=utf8即可!


此时须关闭mysql,删除mysql服务,然后重新启动linux即可!


#cd /usr/local/mysql


#bin/mysqladmin –u root –p shutdown  // 关闭mysql


# /sbin/chkconfig --del mysql               // 删除mysql服务


重新启动linux后,利用以下方法查看效果:


#cd /usr/local/mysql


#bin/mysqladmin variables;


可以该命令列出的参数中看到一些象windows中类似的参数如character-set-server, character-set-connection, character-set-client, character-set-system, character-set-database等均已改成uft8,则配置编码方式为utf8成功!


操作mysql:


如select, insert, delete, update的方法如同一般的SQL语句;只是每条语句后须加上‘;’号


#cd /usr/local/mysql


#bin/mysql


mysql>use euw3;  // 打开数据库euw3


mysql>show tables; // 查看euw3数据库的所有的表


mysql>select * from websysinfor;


适当修改/root/Tomcat5.0/euw3/Root/WEB-INF/euwHome/euw_config.xml和


/root/Tomcat5.0/euw3/Root/WEB-INF/classes/euw_init.properties中的euwHome存放路径!


有两点须大家在euw3项目中适当修改:


1.     因linux严格区分大小写,则所有表名都须改成小写


2.     因linux只承认/或//来表示路径,则所有路径都须修改成/(或//)


然后打开浏览器,输入http://192.168.1.191/showroom/admin/logon.jsp,你就可以看到euw3项目的登录界面了!

We would like to notify you that L4RGE.com is now open for service.  We have completed the beta tests and are ready to register you all once again.  We would like to take the time to thank you for being patient these past months, waiting for our re-launch.  Now that we are re-open, we encourage you all to re-subscribe by visiting http://www.l4rge.com/register.php .


Our new service now includes an optimized control panel which is built for speed and reliability.  Our servers are now running on 99.9% up-time reliability since our BETA testing in late November 2008.


Our features are still un-parallel and include the following:

  • 500 MB of Disk Space
  • Unlimited Bandwidth Usage
  • Free Domain Parking
  • Free Email with Domain
  • 3 MySQL Databases
  • Built in MySQL Editor
  • Full FTP Access
  • And more!

Remember that L4RGE.com is Ad-Free!  We do not believe in forcing ads on users sites, or requiring you to visit forums "to post for host".


For more information we invite you to contact us via http://www.l4rge.com/support/


We hope to see you all back on our new servers....


Wishing you all the best!


Best Regards,

- Marc & Alex

(L4RGE.com Owners)

*********************************

To modify your subscription settings or to unsubscribe, please visit:

http://mail.l4rge.com

 


 


 


申请地址: http://l4rge.com/register_continue.php


演示: http://loveni.l4rge.com/

i6™ gives you lightning fast performance, great service, 24/7 support, FREE stats, storefront building software, web site control panel, cgi, php, mysql and much more!



Requirements: You must have an established site 30 days (1 month) or older to join.



Advertisements/Popup Ads------------------None

Setup Fee---------------------------------Free

Monthly Fee-------------------------------Free

Storage Space-----------------------------5,000 MB

Bandwidth Traffic-------------------------1,000 Gb (1TB)

Hits Per Month----------------------------Unmetered

Your own CGI-bin--------------------------Yes

oScommerce + 100 PHP Scripts--------------Yes

Secure Server (https://SSL)---------------Yes

Detailed Web statistics-------------------Yes

POP3 Email accounts-----------------------100

Email Autoresponders----------------------100

Email Forwarding--------------------------100

Email Aliases-----------------------------100

Web-based E-Mail Access-------------------Yes

Subdomains--------------------------------100

Domain Pointers---------------------------100

FTP Accounts------------------------------100

Virtual FTP Server------------------------Yes

CPANEL Control Panel----------------------Yes

Account Setup Time------------------------6 Hours



申请地址:http://www.i6networks.com/signup.shtml

ATBHost.net would like to be your free hosting provider. We currently offer four packages ranging from totally free and no ads, post-4-host, and ad-supported.





演示:http://67.225.189.40/~loveni/



申请:http://atbhost.net/ipanel/order/



Free

1 GB space

10 GB bandwidth

1 E-mail Account

10 MySQL Databases

10 FTP accounts

10 Add-on Domains

Totally free no ads or posting.



Post-4-Host 1

5 GB space

50 GB bandwidth

10 E-mail Account

25 MySQL Databases

25 FTP accounts

25 Add-on Domains

5 posts to sign-up 10/month to continue.



Post-4-Host 2

10 GB space

100 GB bandwidth

50 E-mail Account

50 MySQL Databases

50 FTP accounts

50 Add-on Domains

5 posts to sign-up 20/month to continue.



Ad-Supported

10 GB space

100 GB bandwidth

50 E-mail Account

50 MySQL Databases

50 FTP accounts

50 Add-on Domains

No posts required, but ads on your site.



All of the packages include:



Apache 2.2.11

PHP 5.2.6

MySQL 5.0.67 w/PHPmyAdmin

Sendmail

Perl

CGI

Ruby on Rails

Frontpage Extensions

Traffic analyzer

Cpanel 11.24.4

Fantastico De Luxe

Free .co.cc domain name



Legal adult hosting is allowed.



If you have any further questions you can reply here or in the ATBHost forums.



Thank you for looking!

  1. 1