Trim and Export and Import the XtreamUI & Codes Database as sql or gzip manually

 
ou can trim your Database and remove the useless entries. This will clear the tables client_logs and user_activity,


1. Install WinSCP
2. Install Putty
3. connect with WinSCP to your Server
4. open Putty
5. Connect to the Database

Bash:
mysql -u root -p

At the Enter password: prompt, well, enter mySQL Root Password

6. Select Xtream Codes Database

Bash:
mysql> USE xtream_iptvpro;

7. Trim your Database and remove the useless entries with:

Bash:
mysql> TRUNCATE TABLE client_logs;
mysql> TRUNCATE TABLE user_activity;
mysql> TRUNCATE TABLE user_activity_now;
mysql> TRUNCATE TABLE reg_userlog;
mysql> TRUNCATE TABLE epg_data;
mysql> TRUNCATE TABLE streams_sys;
mysql> TRUNCATE TABLE stream_logs;
mysql> TRUNCATE TABLE streams_options;

mysql> exit;

8. Export Xtream Codes Database as gzip manually

Bash:
mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup.sql.gz

Export Xtream Codes Database with Timestamp and as gzip manually

Bash:
mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup_$(date "+%b_%d_%Y_%H_%M_%S").sql.gz

At the Enter password: prompt, enter again mySQL Root Password

9. Download with WinSCP the Backup File from /root Folder to your local PC

Importing the DB Dump in to the new DB

As .sql file

Bash:
mysql -u root  -p xtream_iptvpro < [filename].sql

As gunzip archived sql (.sql.gz) File

Bash:
gunzip < databasefile.sql.gz | mysql -u root -p xtream_iptvpro
or
zcat databasefile.sql.gz | mysql -u root -p xtream_iptvpro
  • Export and Import, XtreamUI, Xtream-Codes, XtreamCP Database
 
這篇文章有幫助嗎? 0 Users Found This Useful (0 Votes)