Hey there
I received my xbstream file from percona and I would like to open it as csv file
I extracted the file using xbstream command and I got around 3000 files in QP ending now what
Hi @Jerry1337
xbstream format will the transiet format to stream files from two nodes. The end result files are binary files, not suitable to be open as CSV.
I extracted the file using xbstream command and I got around 3000 files in QP ending now what
It seems like the original backup used compression. Now you need to decompress the files either manually using qpress or using xtrabackup --decompress --target-dir=/folder/with/qpress/files
@Jerry1337 CSV stands for comma-separated-values, which is a string/text-based file type. This is akin to a logical backup. Xtrabackup creates physical backups which are binary files, not text. If you want a logical backup, check out mydumper. If you want CSV, you’ll need to use mysqldump.
done all the required commands
xbstream and then decompress the qp files
now what 
can i run and view the information as local host “server”
@Jerry1337, once again, xbstream is used for physical backups. You cannot read the files with a text editor. You must restore the database files to a MySQL server and start MySQL in order to read the files.
That is exactly as I done and tried to do at the past hours
small summary
XBSTREAM>QP > dozens of files from WP files, to ibd, to ibdata to cnf etc
I received 2 files at the past from Percona I got into the point that I dont have a clue how to procced I even tried to use Percona server but with no success
Could I speak with an agent to solve this issue? (I will pay for this assistant if required)
@Jerry1337, you can contact us here: Sales & General Inquiries - Percona