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:Yesterday 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:Yesterday 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
4883 Views
Last post July 23, 2015, 09:43:28 PM
by Chip
21 Replies
6135 Views
Last post July 10, 2016, 02:37:35 AM
by Chip
11 Replies
11603 Views
Last post September 29, 2015, 09:11:31 PM
by St. Theresa
4 Replies
3022 Views
Last post November 23, 2015, 04:04:12 AM
by Sand and Water
7 Replies
10272 Views
Last post November 09, 2015, 01:37:57 PM
by Chip
4 Replies
2686 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
6214 Views
Last post February 07, 2016, 05:17:12 AM
by Zoops
8 Replies
10650 Views
Last post February 26, 2018, 03:20:36 PM
by Chip
3 Replies
5528 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