Menu
Alright, so here is the scenario
I performed a full backup on my mysql server today. Now when I try to import that .sql dump file, I get the error mentioned in the title and it does not load all the other databases.
How can I get around this so phymyadmin will allow me to import the whole file, or is there a way I could "remove" information_schema from the sql dump
Thanks
896
An error is something you have done which is considered to be incorrect or wrong, or which should not have been done. NASA discovered a mathematical error in its calculations. [ + in]
Some common synonyms of error are blunder, lapse, mistake, and slip. While all these words mean "a departure from what is true, right, or proper," error suggests the existence of a standard or guide and a straying from the right course through failure to make effective use of this.
Antonyms. rightness correctness natural object overgarment better. incorrectness wrongness erroneousness.
As Dan Grossman said:
To "remove" information_schema from the dump, open the file in notepad and delete those lines. It's just a text file of sequential queries to run.
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
