Error message

  • Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in include_once() (line 1389 of /Library/Server/Web/Data/Sites/Documents/jonathansblog/includes/bootstrap.inc).
  • Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in require_once() (line 341 of /Library/Server/Web/Data/Sites/Documents/jonathansblog/includes/module.inc).

Warning message

The service having id "facebook_widget" is missing, reactivate its module or save again the list of services.

Backup, Backup, Backup...before a server upgrade

Categories:

Q. What should you always do before you make any BIG changes to your system?

A. Backup

...and I didn't. In the latest Apple OS X 10.3.3 Server update, some changes were made to the MySQL package, uh oh. Luckily, I think I've got away with it this time, apart from one database table being screwed up. Not a show stopper though - it counted the number of 'reads' each blog article had. Useful data, but I've reset the counters today.

Might be worth reading this....

Data stored in MySQL databases with the version of MySQL that is pre-installed Mac OS X Server 10.3.2 or earlier must be exported and re-imported in order to be compatible with version of MySQL that is pre-installed on Mac OS X Server 10.3.3, in which a byte-ordering issue is fixed.

As with any upgrade install, you should back up your old data. In this particular upgrade, the following process is recommended to convert the data to the correct byte ordering:

Before the upgrade, use the terminal to export the data from your pre-10.3.3 database:

# ??mysqldump -p table > backup-file.sql

or

# ??mysqldump ??--opt database > backup-file.sql

After the upgrade, and after initializing the MySQL database, import the data:

# ??mysql -p table < backup-file.sql

or

# ??mysql ??database < backup-file.sql

Add new comment

Filtered HTML

  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Image CAPTCHA
Enter the characters shown in the image.