phpmyadmin导入恢复和导出备份mysql数据库（适用虚拟主机和vps弹性云）_威海佰年网络技术有限公司_网站建设_软件开发_私有云_商标注册_公众号_小程序_APP_物联网_ChatGPT

Categories

Tags

phpmyadmin导入恢复和导出备份mysql数据库（适用虚拟主机和vps弹性云）

威海网站建设威海phpmyadmin
2924

对于虚拟主机和VPS弹性云的用户来说，备份和恢复MySQL数据库是非常重要的工作。在phpMyAdmin中，备份和恢复MySQL数据库很容易，我们只需要按照以下步骤即可：导出备份MySQL数据库： 1.登录phpMyAdmin 2.选择需要备份的数据库 3.点击“导出”按钮 4.选择要导出的数据表，然后选择“导出方式” 5.选择“导出选定项”，然后选择“SQL”，然后点击“Go” 6.然后选择备份文件的保存路径，然后点击“保存” 7.备份文件将保存到您指定的路径中。导入恢复MySQL数据库： 1.登录phpMyAdmin 2.选择需要恢复的数据库 3.点击“导入”按钮 4.点击“选择文件”，然后选择要导入的备份文件 5.选择“SQL”，然后点击“Go” 6.等待导入完成。注意：在数据库恢复过程中，您需要确保服务器上没有相同的数据库或数据表，否则您将会丢失所有数据。

Public @ 2023-03-30 08:00:19

FTP软件的安装及上传/下载方法

威海网站建设威海FTP
2897

一、FTP软件下载及使用：FileZilla 软件下载地址：http://downinfo.myhostadmin.net/FileZilla-3.51.0.zipFLashFXP下载地址: http://downinfo.myhostadmin.net/FlashFXP.zip版权说明：ftp软件来源收集于互联网，若涉及侵权请联系我们。更多版本下载，请访问官方地址：https://www.fil

Public @ 2018-04-03 15:45:58

西部数码部分主机缓存清理方法

为提高网站访问速度，我司对部分主机静态文件进行了缓存。一、存在缓存的主机：1.港台虚拟主机2.亚数机房云服务器的香港线路3.国内双线虚拟主机移动节点、国内多线虚拟主机移动节点4.智能多线云服务器移动节点二、缓存规则js/css/swf 这些文件存在缓存，其它文件不存在缓存。缓存时间：24小时。三、清理缓存方法1.单个文件缓存清理方法：在域名/后面增加_qhc，再加上文件路径即可：如需清理http:

Public @ 2021-08-16 16:00:45

VPS、弹性云使用phpmyadmin导入导出MySQL数据库

1. 登录phpmyadmin 使用VPS或弹性云服务器，首先需要登录phpmyadmin控制面板。访问网站的URL后，并在网站后加上“/phpmyadmin”即可进入登录页面。输入正确的用户名和密码进行登录。 2. 进入数据库进入phpmyadmin控制面板后，会显示所有的数据库。选择要导入或导出的数据库并进入。 3. 导出MySQL数据库要导出MySQL数据库，选择导航栏上的“导

Public @ 2023-04-17 09:00:11

VPS、弹性云使用phpmyadmin导入导出MySQL数据库

以下是使用phpMyAdmin导入和导出MySQL数据库的步骤： 1. 登录VPS或弹性云的phpMyAdmin，选择要导入或导出的数据库。 2. 对于导出数据库，点击“导出”，选择适当的选项，如“快速”、“自定义”等，并选择要导出的表。然后点击“Go”。 3. 对于导入数据库，点击“导入”，选择要导入的SQL文件，并选择适当的选项。然后点击“Go”。如果导入或导出的数据库很大，可能需要

Public @ 2023-04-29 07:00:07

更多您感兴趣的搜索

基本文件流程错误 SQL 调试

/www/wwwroot/bninc.cn/public/index.php ( 0.79 KB )
/www/wwwroot/bninc.cn/public/public.php ( 1.08 KB )
/www/wwwroot/bninc.cn/thinkphp/start.php ( 0.73 KB )
/www/wwwroot/bninc.cn/thinkphp/base.php ( 2.66 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Loader.php ( 19.47 KB )
/www/wwwroot/bninc.cn/vendor/composer/autoload_namespaces.php ( 0.21 KB )
/www/wwwroot/bninc.cn/vendor/composer/autoload_psr4.php ( 0.84 KB )
/www/wwwroot/bninc.cn/vendor/composer/autoload_classmap.php ( 0.14 KB )
/www/wwwroot/bninc.cn/vendor/composer/autoload_files.php ( 0.42 KB )
/www/wwwroot/bninc.cn/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
/www/wwwroot/bninc.cn/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
/www/wwwroot/bninc.cn/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Route.php ( 59.82 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Config.php ( 6.03 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Validate.php ( 40.27 KB )
/www/wwwroot/bninc.cn/vendor/topthink/think-queue/src/config.php ( 0.77 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Console.php ( 21.22 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Error.php ( 3.59 KB )
/www/wwwroot/bninc.cn/thinkphp/convention.php ( 10.31 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/App.php ( 21.04 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Request.php ( 50.94 KB )
/www/wwwroot/bninc.cn/app/config.php ( 11.25 KB )
/www/wwwroot/bninc.cn/app/database.php ( 1.41 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Hook.php ( 4.76 KB )
/www/wwwroot/bninc.cn/app/tags.php ( 1.16 KB )
/www/wwwroot/bninc.cn/app/common/behavior/InitBase.php ( 8.17 KB )
/www/wwwroot/bninc.cn/app/common.php ( 23.29 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Env.php ( 1.25 KB )
/www/wwwroot/bninc.cn/thinkphp/helper.php ( 17.86 KB )
/www/wwwroot/bninc.cn/app/function.php ( 0.78 KB )
/www/wwwroot/bninc.cn/app/extend.php ( 13.29 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Debug.php ( 7.06 KB )
/www/wwwroot/bninc.cn/app/common/model/Config.php ( 0.78 KB )
/www/wwwroot/bninc.cn/app/common/model/ModelBase.php ( 12.18 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Model.php ( 66.83 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Db.php ( 6.54 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Log.php ( 5.84 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/db/Query.php ( 86.80 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/db/Builder.php ( 30.47 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Cache.php ( 6.17 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/cache/driver/File.php ( 7.46 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
/www/wwwroot/bninc.cn/app/common/behavior/InitHook.php ( 1.25 KB )
/www/wwwroot/bninc.cn/app/common/model/Hook.php ( 0.77 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Lang.php ( 6.95 KB )
/www/wwwroot/bninc.cn/thinkphp/lang/zh-cn.php ( 3.85 KB )
/www/wwwroot/bninc.cn/app/route.php ( 0.91 KB )
/www/wwwroot/bninc.cn/app/index/config.php ( 0.96 KB )
/www/wwwroot/bninc.cn/app/index/common.php ( 0.68 KB )
/www/wwwroot/bninc.cn/app/index/controller/Wiki.php ( 2.44 KB )
/www/wwwroot/bninc.cn/app/index/controller/IndexBase.php ( 1.10 KB )
/www/wwwroot/bninc.cn/app/common/controller/ControllerBase.php ( 4.75 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Controller.php ( 6.20 KB )
/www/wwwroot/bninc.cn/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/View.php ( 6.86 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Template.php ( 46.46 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/bninc.cn/app/index/logic/Wiki.php ( 6.16 KB )
/www/wwwroot/bninc.cn/app/index/logic/IndexBase.php ( 0.79 KB )
/www/wwwroot/bninc.cn/app/common/logic/LogicBase.php ( 0.83 KB )
/www/wwwroot/bninc.cn/app/common/model/Article.php ( 0.78 KB )
/www/wwwroot/bninc.cn/app/common/model/ArticleTongji.php ( 0.79 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.90 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Paginator.php ( 9.45 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Collection.php ( 8.63 KB )
/www/wwwroot/bninc.cn/runtime/temp/fd12b1d7af823e9ae53201dacc6a6621.php ( 56.49 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/Response.php ( 8.64 KB )
/www/wwwroot/bninc.cn/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ DB ] CONNECT:[ UseTime:0.025743s ] mysql:dbname=briline.net;host=106.14.77.182;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.017959s ]
[ SQL ] SELECT * FROM `ob_article` WHERE `id` = 6524 LIMIT 1 [ RunTime:0.018872s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='cate' order by times desc limit 15 [ RunTime:0.017452s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by times desc limit 100 [ RunTime:0.018069s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by rand() limit 30 [ RunTime:0.017678s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `id` = 6524 LIMIT 1 [ RunTime:0.017271s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] update `ob_article` set views=views+1 where id=6524 [ RunTime:0.017984s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海网站建设' AND `status` <> -1 LIMIT 1 [ RunTime:0.023911s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9541, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海网站建设' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.044874s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9541, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海phpmyadmin' AND `status` <> -1 LIMIT 1 [ RunTime:0.023704s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9541, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海phpmyadmin' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.033642s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9541, 'extra' => 'Using where; Using temporary; Using filesort', ) ]

0.503535s

ShowPageTrace