phpmyadmin 导入大数据的方法
phpMyAdmin目录下新建一个目录,如:importsqlfile,再编辑phpMyAdmin目录下libraries\config.default.php文件,
查找$cfg['UploadDir'],将其值写为新建目录的名称,如下所示:
代码:
$cfg['UploadDir'] = ‘jonson’;// Directory for uploaded files that can be executed by
// phpMyAdmin. For example ‘./upload’. Leave empty for
// no upload directory support. Use %u for username
// inclusion.
$cfg['SaveDir'] = ”; // Directory where phpMyAdmin can save exported data on
// server. For example ‘./save’. Leave empty for no save
// directory support. Use %u for username inclusion.
将要导入到数据库的文件上传到刚才新建的importsqlfile文件夹中,登录phpMyAdmin,选择你的数据库,在右侧窗口中点击“import(导入)”,这时你会发现导入界面中多了一个“网站服务器上载目录”选项,点击下拉箭头,列表里会有刚才上传的文件名称列表。
选中文件,点击右下角的“执行”按钮,等待一段时间(等待的时间与导入文件体积成正比)即可完成“超重”文件的导入。
I WAS REALLY PLEASED THAT SOMEONE HAS EXPRESSED SOMETHING NEW…
LET ME SHARE
Time will tell
That’s an article worth imagining!!!
my friend, I am sending you peaceful and positive thoughts and lots of love. Blessed Be
hello well respected ,honest and critical human soul
Your words are so very true. We all need to be reminded. Thank you!
so thanks for teaching me!!
Даужж никогда не думал об этом …
Thank you for the article!
Thank you all for the wonderful comments.
I am glad you provide us with a living example for us to learn and be inspired by.
What is the purpose of this website if you don’t mind me asking?
Hey, nice art i add your blog to my rss!
I just added your blog site to my blogroll, I pray you would give some thought to doing the same.
Beneficial info and excellent design you got here! I want to thank you for sharing your ideas and putting the time into the stuff you publish! Great work!