问一个数据库问题

鼕菇蒸鷄 · 发表于 2006-8-29 16:31:04

我想问一下..我在phpMyAdmin导出数据出来..因为他大了..有50多m
不知道可不可以下在的时候分割呢?
以为数据上传最大是51M
有什么方法把一个数据分割成几个呢?

ghol · 发表于 2006-8-29 16:37:14

有这样的玩具的，我帮你找一下看看啊。

ghol · 发表于 2006-8-29 16:39:10

http://down.sxxsw.com/soft/3748.htm

Q2C · 发表于 2006-8-29 16:41:04

导入也好容易

Q2C · 发表于 2006-8-29 16:41:58

去下载mysql_tool,我将200M 的MYSQL数据也是这样导入空间上,而且无错,30分钟导入好了

鼕菇蒸鷄 · 发表于 2006-8-29 16:55:20

谢谢大家的帮忙

:

Q2C · 发表于 2006-8-29 17:11:58

当时我试了N个脚本都不能将大型的数据库恢复,只有mysql_tool可以,真不错的脚本

ghol · 发表于 2006-8-29 17:21:13

俺刚刚推荐的那个好象是可以的。

anything · 发表于 2006-8-29 17:28:30

导出gzip可以压到近一半。

鼕菇蒸鷄 · 发表于 2006-8-29 17:32:15

原帖由 anything 于 2006-8-29 17:28 发表
导出gzip可以压到近一半。

是的．．大概也很大啊．．昨天晚上试了我一晚了．．郁闷

显示全部楼层 · 发表于 2006-8-29 17:36:15

提示: 作者被禁止或删除内容自动屏蔽

winner01 · 发表于 2006-8-29 19:38:03

不错！

鼕菇蒸鷄 · 发表于 2006-8-29 19:56:14

mysql_tool
这个我运行有问题．
郁闷

Q2C · 发表于 2006-8-29 20:09:57

原帖由 鼕菇蒸鷄 于 2006-8-29 19:56 发表
mysql_tool
这个我运行有问题．
郁闷

没有设好权限还是你的数据库设错

鼕菇蒸鷄 · 发表于 2006-8-29 20:36:10

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/paidcom/public_html/123456a/mysql_tool/mysql_tool.php on line 635

备份完成
数据备份已经完成,文件保存为:"sql_backup.sql".

点击这里下载备份文件

[ 返回 ] [ 退出 ]

鼕菇蒸鷄 · 发表于 2006-8-29 20:37:17

把目录设置了７７７．．就无法访问了
把他设置回来７５５就能够访问．但是出错

Q2C · 发表于 2006-8-29 22:00:01

你用啥方式上传?二进制?

Q2C · 发表于 2006-8-29 22:00:37

用二进制试一试吧

anything · 发表于 2006-8-29 22:31:58

flashfxp设成自动啊，所有nt or nix都OK啊。

鼕菇蒸鷄 · 发表于 2006-8-30 00:41:51

好的

显示全部楼层 · 发表于 2006-8-30 02:49:40

提示: 作者被禁止或删除内容自动屏蔽

Q2C · 发表于 2006-8-30 03:14:50

我在hostgator空间上正常得很

utraffic 该用户已被删除	发表于 2006-8-29 17:36:15 \| 显示全部楼层提示: 作者被禁止或删除内容自动屏蔽
utraffic 该用户已被删除
	回复给力爆菊使用道具举报

utraffic 该用户已被删除	发表于 2006-8-30 02:49:40 \| 显示全部楼层提示: 作者被禁止或删除内容自动屏蔽
utraffic 该用户已被删除
	回复给力爆菊使用道具举报

问一个数据库问题

相关帖子

回复 #7 Q2C 的帖子