vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   How to take a database backup from phpmyadmin? (https://vborg.vbsupport.ru/showthread.php?t=315403)

XYZ500 11-13-2014 07:04 PM
How to take a database backup from phpmyadmin?
 
I am about to change hosts. I want to take a complete backup of the forum so I can restore it on the new host. I can simple copy all the website files, thats easy. But taking the mySQL database backup is difficult. How can I go about doing so in phpmyadmin?

Dave 11-13-2014 07:10 PM
There should be an "Export" button in PHPMyAdmin, you use that to export the database.
You can also do it on SSH which is easier and has no limitations. With PHPMyAdmin there may be size limits and time-outs.

Lynne 11-14-2014 05:04 PM
Dave is correct in that if you have a large database and use phpMyAdmin to back it up, it could time out (and you may not know it!). So, if you do use phpMyAdmin, make sure to then create a new database and import it there. Then point a test site at this database to verify it is all there (or check the tables and make sure they are all there).

The best way to take a database backup is via ssh.

From the manual:
Backing Up The Database via SSH/Telnet or
Backing Up The Database via phpMyAdmin


All times are GMT. The time now is 02:18 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00962 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete