dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse

This website has run out of funding so feel free to contribute if you can afford it (see footer)

Author Topic: Database Backups (and some phpmyadmin Import/Exports)  (Read 158 times)

andrew

  • Guest
Database Backups (and some phpmyadmin Import/Exports)
« on: December 23, 2014, 07:04:53 PM »
Batch Method:

mysqldump -u root -pXXXX --all-databases > /SQL/database_`date '+%m-%d-%Y'`.sql
« Last Edit: March 30, 2015, 06:15:51 PM by andrew »
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions

andrew

  • Guest
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions

Offline Chip

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 05:53:23 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: Database Backups
« Reply #2 on: March 03, 2015, 07:50:12 AM »
best way is phpmyadmin database export / import.

tip: CLICK on "save file" or something that creates the actual file.

move file from above to download(/upload) and then upload to the intranet's test system.

effectivley cloning all of SMF !

get used to mysql as you need to drop and create database smf209 at the appropriate times.
« Last Edit: March 24, 2015, 04:53:22 AM by andrew »
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline Chip

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Today at 05:53:23 PM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: Database Backups
« Reply #3 on: March 09, 2015, 03:57:56 PM »
cron runs "dbback" (mysqldump) hourly, on the 1st. minute and writes into "/SQL" 
« Last Edit: March 09, 2015, 04:17:07 PM by Chipper »
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
4860 Views
Last post July 23, 2015, 09:43:28 PM
by Chip
21 Replies
6134 Views
Last post July 10, 2016, 02:37:35 AM
by Chip
11 Replies
11599 Views
Last post September 29, 2015, 09:11:31 PM
by St. Theresa
4 Replies
3020 Views
Last post November 23, 2015, 04:04:12 AM
by Sand and Water
7 Replies
10265 Views
Last post November 09, 2015, 01:37:57 PM
by Chip
4 Replies
2685 Views
Last post November 04, 2015, 04:57:07 PM
by Chip
8 Replies
8547 Views
Last post December 11, 2015, 06:44:44 PM
by Diacetylmorphinefiend
3 Replies
6212 Views
Last post February 07, 2016, 05:17:12 AM
by Zoops
8 Replies
10648 Views
Last post February 26, 2018, 03:20:36 PM
by Chip
3 Replies
5522 Views
Last post August 28, 2017, 03:04:10 AM
by Chip


dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse





TERMS AND CONDITIONS

In no event will d&u or any person involved in creating, producing, or distributing site information be liable for any direct, indirect, incidental, punitive, special or consequential damages arising out of the use of or inability to use d&u. You agree to indemnify and hold harmless d&u, its domain founders, sponsors, maintainers, server administrators, volunteers and contributors from and against all liability, claims, damages, costs and expenses, including legal fees, that arise directly or indirectly from the use of any part of the d&u site.


TO USE THIS WEBSITE YOU MUST AGREE TO THE TERMS AND CONDITIONS ABOVE


Founded December 2014
SimplePortal 2.3.6 © 2008-2014, SimplePortal