Altrea wrote:no
It sad me to know that
Altrea wrote:no
Altrea wrote:Did you compare the two dumps?
Some dumps contain meta information which can extend the file size.
Froosh wrote:mysqldump command options are the only thing I can come up with.
xiro911 wrote:any explanation for how this happens?
Nobbie wrote:xiro911 wrote: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).
Altrea wrote: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?
Altrea wrote:of course they are of different file size.
these are two completely different methods taking an database export of the same data.
Users browsing this forum: No registered users and 63 guests