Have you ever experienced a situation where one moment you can
connect to the MySQL database and the next moment you
cannot, only to be able to connect again a second later? As you
may know one cannot open infinite connections with MySQL. There’s
a practical limit and more often than not it is imposed by the
underlying operating system. If you’re getting:

Everybody knows the criticality of backup. You might have had
your database dumped, data directory copied, flat files exported
and even config and binary log files backed-up. But did you
backup your MySQL user privileges? One can easily forget to
backup the user privileges but it is much easier to do and you
should backup […]

Ever come accoss a situation where you have to load a flat text
file into MySQL with data provided in single column! Say, your
data to be loaded in table looks something like this: Company1
Street Name City, MyState 8582 (999)999-999 another_Company
Another Street 2 New City, NWSTATE 8582 (111)111-1111 So how’d
you go about […]

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.