3
Is there an automatic backup system? In my table there was a CNPJ field that contained Cnpjs and Cpfs, it was the type varchar I switched to the guy int and screwed it all up.
1 answer
3
I believe that nay there is nothing ready, unless your server/administrators have implemented something, so only by contacting technical support and/or server administrators to request a copy of the backup.
If you have nothing implemented on your server it will not be possible to restore.
When making modifications it is always good to test on your local machine first, to avoid these kinds of problems.
Backup suggestions to avoid problems futures:
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
Always back up before changing anything in a database that is in production.
– bfavaretto
Have you set up to back up on the server? some cron? something to do automatically? else and pretty unlikely.
– Diego Braga
@I don’t know if it’s duplicate. By description, he wants to know if mysql would do, alone, by default, some backup that would allow him to recover the lost data.
– bfavaretto
I also think these are the only ways to back up. So the answer here would be "no", @Guilhermenascimento
– bfavaretto
@bfavaretto so is, I focused on the title and the first line, adjusted the question to avoid confusion
– Guilherme Nascimento