Maintenance - Revision history

AlexN: Redirected page to Restoring WHMCS

2021-08-12T13:33:40Z

Redirected page to Restoring WHMCS

AlexN: Redirected page to Testing WHMCS

2021-01-12T13:13:24Z

Redirected page to Testing WHMCS

AlexN at 13:13, 12 January 2021

2021-01-12T13:13:08Z

AlexN at 14:31, 11 January 2021

2021-01-11T14:31:38Z

AlexN at 14:29, 11 January 2021

2021-01-11T14:29:35Z

Lawrence: /* Resetting your database */

2020-10-27T12:25:55Z

‎Resetting your database

John at 13:03, 26 October 2020

2020-10-26T13:03:33Z

John: /* Resetting your database */

2020-10-03T10:43:28Z

‎Resetting your database

John at 16:23, 7 September 2020

2020-09-07T16:23:33Z

SarahK: /* Backing up your WHMCS Database */

2020-08-27T20:39:14Z

‎Backing up your WHMCS Database

← Older revision		Revision as of 13:33, 12 August 2021
Line 1:		Line 1:
−	#REDIRECT [[~~Testing_WHMCS~~]]	+	#REDIRECT [[Restoring_WHMCS]]

← Older revision		Revision as of 13:13, 12 January 2021
Line 1:		Line 1:
−	~~__TOC__~~
	#REDIRECT [[Testing_WHMCS]]		#REDIRECT [[Testing_WHMCS]]
−	~~==Resetting your database==~~
−	After you successfully install your billing system, run through a series of tests, including creating client accounts and placing test orders with your particular setup. Often, after you have finished your testing, you will no longer want any of these clients or orders in your system. All you need to do is reset your system, which will remove all of your test accounts.
−
−	~~You can empty all the tables that contain clients' data by running the following SQL code on your database:~~
−
−	~~<div class="source-cli">~~
−	~~TRUNCATE `mod_invoicedata` ;~~
−	~~<br/>TRUNCATE `tblinvoicedata` ;~~
−	~~<br/>TRUNCATE `tblaccounts` ;~~
−	~~<br/>TRUNCATE `tblactivitylog` ;~~
−	~~<br/>TRUNCATE `tblaffiliates` ;~~
−	~~<br/>TRUNCATE `tblaffiliatesaccounts` ;~~
−	~~<br/>TRUNCATE `tblaffiliateshistory` ;~~
−	~~<br/>TRUNCATE `tblaffiliatespending` ;~~
−	~~<br/>TRUNCATE `tblaffiliateswithdrawals` ;~~
−	~~<br/>TRUNCATE `tblbankaccts`;~~
−	~~<br/>TRUNCATE `tblbillableitems` ;~~
−	~~<br/>TRUNCATE `tblcancelrequests` ;~~
−	~~<br/>TRUNCATE `tblclients` ;~~
−	~~<br/>TRUNCATE `tblclientsfiles` ;~~
−	~~<br/>TRUNCATE `tblcontacts` ;~~
−	~~<br/>TRUNCATE `tblcredit` ;~~
−	~~<br/>TRUNCATE `tblcreditcards`;~~
−	~~<br/>TRUNCATE `tblcustomfieldsvalues` ;~~
−	~~<br/>TRUNCATE `tbldomains` ;~~
−	~~<br/>TRUNCATE `tbldomainsadditionalfields` ;~~
−	~~<br/>TRUNCATE `tblemails` ;~~
−	~~<br/>TRUNCATE `tblhosting` ;~~
−	~~<br/>TRUNCATE `tblhostingaddons` ;~~
−	~~<br/>TRUNCATE `tblhostingconfigoptions` ;~~
−	~~<br/>TRUNCATE `tblinvoiceitems` ;~~
−	~~<br/>TRUNCATE `tblinvoices` ;~~
−	~~<br/>TRUNCATE `tblmodulequeue` ;~~
−	~~<br/>TRUNCATE `tblnotes` ;~~
−	~~<br/>TRUNCATE `tblorders` ;~~
−	~~<br/>TRUNCATE `tblpaymethods`;~~
−	~~<br/>TRUNCATE `tblquotes` ;~~
−	~~<br/>TRUNCATE `tblquoteitems` ;~~
−	~~<br/>TRUNCATE `tblsslorders` ;~~
−	~~<br/>TRUNCATE `tblticketlog` ;~~
−	~~<br/>TRUNCATE `tblticketnotes` ;~~
−	~~<br/>TRUNCATE `tblticketreplies` ;~~
−	~~<br/>TRUNCATE `tbltickets` ;~~
−	~~<br/>TRUNCATE `tblupgrades` ;~~
−	~~<br/>TRUNCATE `tblusers`;~~
−	~~<br/>TRUNCATE `tblusers_clients`;~~
−	~~<br/>TRUNCATE `tbluser_invites`;~~
−	~~</div>~~
−
−	~~<div class="docs-alert-warning">~~
−	~~<span class="title">Note</span><br />~~
−	~~Resetting your database only deletes client accounts and information. You will not lose any configuration or product settings.~~
−	~~</div>~~

@@ Line 1: / Line 1: @@
 __TOC__
 ==Resetting your database==
 After you successfully install your billing system, run through a series of tests, including creating client accounts and placing test orders with your particular setup. Often, after you have finished your testing, you will no longer want any of these clients or orders in your system.  All you need to do is reset your system, which will remove all of your test accounts.

← Older revision		Revision as of 14:31, 11 January 2021
Line 53:		Line 53:
	Resetting your database only deletes client accounts and information. You will not lose any configuration or product settings.		Resetting your database only deletes client accounts and information. You will not lose any configuration or product settings.
	</div>		</div>
−
−	~~==Restoring a Database Backup==~~
−	~~If you need to restore a backup of your database, you will first need to recreate your database, if you haven't already, and drop the existing WHMCS tables.~~
−
−	~~To restore a database:~~
−
−	~~#Log in to phpMyAdmin and select the database you want to restore.~~
−	~~#Click the '''Import''' tab at the top: <br /><br />[[Image:maintenance1.png]] <br /><br />~~
−	~~#Click the '''Browse''' button.~~
−	~~#Find your backup file and then press '''OK'''.~~
−	~~#Click '''Go'''. <br /><br />[[Image:maintenance2.png]]~~

@@ Line 53: / Line 53: @@
 Resetting your database only deletes client accounts and information. You will not lose any configuration or product settings.
 </div>
 ==Restoring a Database Backup==

@@ Line 32: / Line 32: @@
 <br/>TRUNCATE `tblinvoiceitems` ;
 <br/>TRUNCATE `tblinvoices` ;
 <br/>TRUNCATE `tblnotes` ;
 <br/>TRUNCATE `tblorders` ;

@@ Line 6: / Line 6: @@
 <div class="source-cli">
-TRUNCATE `tblinvoicedata` ;
+TRUNCATE `mod_invoicedata` ;
 <br/>TRUNCATE `tblaccounts` ;
 <br/>TRUNCATE `tblactivitylog` ;

@@ Line 14: / Line 14: @@
 <br/>TRUNCATE `tblaffiliatespending` ;
 <br/>TRUNCATE `tblaffiliateswithdrawals` ;
-<br/>TRUNCATE `tblbankaccounts`;
+<br/>TRUNCATE `tblbankaccts`;
 <br/>TRUNCATE `tblbillableitems` ;
 <br/>TRUNCATE `tblcancelrequests` ;

@@ Line 53: / Line 53: @@
 #Log in to your WHMCS Admin Area.
-#Go to '''Utilities > Database Status'''.
+#Go to '''Utilities > [[System Utilities|Database Status]]'''.
 #Click the '''Download Full Database Backup''' button at the top of the page. The system will prompt you to download a file.
 #Save the file to your computer. Depending on the database size, this may take a few moments.
 ==Restoring a Database Backup==