export xtream ui database into your local pc

[mohab36]

hello mates i hope you are doing well, i am new member here and this is my first hread

i come with a way to export your mysql database into you local machine and hence you can import it locally for more investigtion and manipulation and this helps a lot especially during issues.

first you need to backup your database using mysqldumb and this disscussed in how to thread by redhat.
you are required to install putty in your local machine.
if you want to investigate and analyse your database you have to install any local web server like xammp or wammp
steps:
after making the backup
open command prompt in the local machine type the following command
pscp -P <sshport> USERNAME@IP_ADDRESS_OF_XTREAM_SERVER:/../tmp/xtream_iptvpro.sql e:\x.


/../tmp/xtream_iptvpro.sql > location of database backup
e:\x. > destination location
then rename the file in your machine x. > xtream_iptvpro.sql
then if you want to import into your local server which must have mysql installed in
export it using red hat thread
hnx in advance mates

 

[urgodfather]

Let me introduce you to a little program called HeidiSQL......

HeidiSQL - MariaDB, MySQL, MSSQL, PostgreSQL and SQLite made easy

HeidiSQL is a free and powerful client for MariaDB, MySQL, Microsoft SQL Server, PostgreSQL and SQLite

www.heidisql.com

equally noob and expert friendly.