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/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.xhtml failed

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