XAMPP Auto Backup

[xiro911]

no

It sad me to know that

[Altrea]

Did you compare the two dumps?
Some dumps contain meta information which can extend the file size.

[xiro911]

Did you compare the two dumps?
Some dumps contain meta information which can extend the file size.

I just compare them by both right-clicking then properties and then check the size. Is that what you mean by checking the dump?

[Froosh]

mysqldump command options are the only thing I can come up with.

[xiro911]

mysqldump command options are the only thing I can come up with.

Is it possible for you to show me how to compare using a MySQLDump?

A good website reference for research would really be appreciated

[Altrea]

there are multiple ways.

easiest would be to import both dumps and count the tables and rows.

or import the auto dump and take a manual dump from that to compare file soze with your other manual dump

or if both dumps are uncompressed plain text dumps (sql files) use something lile the compare plugin from free software Notepad++ to highlight the differences

technically if both dumps are talen with the same batxh file but one of them is triggered by a windows scheduled task they should be identical.

but if your manual dump is a phpmyadmin export and one is a mysqldump dump they can be different but probably contain the same data.

[Nobbie]

any explanation for how this happens?

Tons of options:

1) Did you use exactly the same commandline for "mysqldump" for autobackup / manually backup? Or is there any difference?

2) Did you run both backups exactly at the same time? If not, maybe some records have been changed / added / deleted in the meantime?

3) The output of mysqldump usually is a SQL file. That is a textfile which contains SQL statements to create the tables and records. You can:
a) simply edit the files. Open a texteditor of your choice and have a first view, if you can see any obvious differences.
b) get you a comparison tool, which can compare "similar" textfiles and show the differences. In Linux there are commandline tools like "diff" or "sdiff", probably there should be anything like that in Windows. If not, ask in a Windows forum where to get such tools. Some texteditors can do such comparisons.

And, last not least: Don't act so terribly helpless all the time. Always "sad", "sad", "sad" doesn't help you with anything. "Sad" is that you don't seem to have any computer skills at all. This is a very bad condition to be a system administrator for SQL databases.

Finally, if you still dont know how to proceed, you may upload the auto backup and the corresponding manual backup, so i can download these and i will have a look if i can find out what the differences are. Keep in mind, the size difference could also result from the fact that you might have stored them on different devices. One and the same file can result in different file size (yes!), if you have different harddisks formatted differently (i.e. different segment size).

[Froosh]

I'm beginning to think the user want someone to tell them exactly what to do to make a backup, as apparently they have both automated backups and manual backups already. Then, if they have instructions, and something goes wrong, they can point to the instructions and say "I was just following these instructions..." That is what I am thinking at this point.

[Nobbie]

Actually, I dont know. I do what i can do and thats it. I am not a "support team member" (what might be misunderstood).

[xiro911]

any explanation for how this happens?

Tons of options:

1) Did you use exactly the same commandline for "mysqldump" for autobackup / manually backup? Or is there any difference?

2) Did you run both backups exactly at the same time? If not, maybe some records have been changed / added / deleted in the meantime?

3) The output of mysqldump usually is a SQL file. That is a textfile which contains SQL statements to create the tables and records. You can:
a) simply edit the files. Open a texteditor of your choice and have a first view, if you can see any obvious differences.
b) get you a comparison tool, which can compare "similar" textfiles and show the differences. In Linux there are commandline tools like "diff" or "sdiff", probably there should be anything like that in Windows. If not, ask in a Windows forum where to get such tools. Some texteditors can do such comparisons.

And, last not least: Don't act so terribly helpless all the time. Always "sad", "sad", "sad" doesn't help you with anything. "Sad" is that you don't seem to have any computer skills at all. This is a very bad condition to be a system administrator for SQL databases.

Finally, if you still dont know how to proceed, you may upload the auto backup and the corresponding manual backup, so i can download these and i will have a look if i can find out what the differences are. Keep in mind, the size difference could also result from the fact that you might have stored them on different devices. One and the same file can result in different file size (yes!), if you have different harddisks formatted differently (i.e. different segment size).

Here is my used script

mysqldump -u testline -p~inf0+sy$881 Testline-v2020 > C:\Users\Administrator\Downloads\TestBackUp\TestDB.sql

They are stored on same HDD can't find the reason why theirs .10+ difference or more. I could upload the .sql file for comparison

[xiro911]

1) Did you use exactly the same commandline for "mysqldump" for autobackup / manually backup? Or is there any difference?

For manual just click the button on XAMP choose the specific database and click backup. For auto I use the script from the above reply which I cant find how to edit the post heheh

2) Did you run both backups exactly at the same time? If not, maybe some records have been changed / added / deleted in the meantime?

Yes. So its not possible for any database changes for what I see. That is also why I am wondering what cause the discrepancy of size

[Altrea]

just to clearify: for manual backup you are not using the script, but clicking the Admin Button next to mysql in your XAMPP control panel to open and use phpmyadmin?

[xiro911]

just to clearify: for manual backup you are not using the script, but clicking the Admin Button next to mysql in your XAMPP control panel to open and use phpmyadmin?

Correct....

[Altrea]

of course they are of different file size.
these are two completely different methods taking an database export of the same data.

[xiro911]

of course they are of different file size.
these are two completely different methods taking an database export of the same data.

How could that be they are of different sizes the manual backup and the automatic backup is referring/targeting to the same database. Is the manual backup adding something to the .sql file to make the file a bit larger?