Writing /data1/apache/share/htdocs/wiki/data/cache/9/966275d65584d1575c2f82811505709c.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /data1/apache/share/htdocs/wiki/data/cache/9/966275d65584d1575c2f82811505709c.metadata failed
Writing /data1/apache/share/htdocs/wiki/data/meta/mysql/%E6%95%B0%E6%8D%AE%E5%AF%BC%E5%85%A5%E5%AF%BC%E5%87%BA.meta failed
 
Writing /data1/apache/share/htdocs/wiki/data/cache/5/5346d56014b6975f8facacb2f3d0880a.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /data1/apache/share/htdocs/wiki/data/cache/5/5346d56014b6975f8facacb2f3d0880a.xhtml failed

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

mysql:数据导入导出 [2013/07/02 14:39]
linyi
mysql:数据导入导出 [2019/12/08 02:15] (当前版本)
行 1: 行 1:
 +====== mysql数据导入导出 ======
  
 +一、数据库备份和导出
 +
 +  用以下命令,数据库大小达到几百M,几G都可以。注意“–default-character-set=utf8”是设置编码的。
 +
 +  1.数据库备份命令
 +
 +  mysqldump -h localhost ​ -u   ​root ​  ​-p ​  ​–default-character-set=utf8 ​  ​dbname >​backup.sql
 +
 +  2.导入数据库
 +
 +  mysql -h localhost ​ -u   ​root ​  ​-p ​  ​–default-character-set=utf8
 +
 +  use dbname
 +
 +  source backup.sql
 +
 +#shell 操作mysql的实例
 +
 +  host_string=`host xxxxxxx | awk '​{print $4}'`
 +  for ip in $host_string
 +  do
 +    echo $ip;
 +    mysql -h $ip -Pxxxx -u xxxxx-pxxxxx << eof
 +        use nbagame; ​
 +        $sql;    ​
 +   eof
 +  done
mysql/数据导入导出.txt · 最后更改: 2019/12/08 02:15 (外部编辑)
 
除额外注明的地方外,本维基上的内容按下列许可协议发布: CC Attribution-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki