10. 09. 10
Backing up your database is absolutely vital if the data is of any importance. This will save you in the event of an accidental deletion, either due to a slip of the finger or a major failure in your code.
If you're familiar with phpMyAdmin, then you may be able to export and import your database from there. But this approach doesn't work too well if you have a large database. For large databases, you're better off using the command line.
Backup Your MySQL Database
Log in to the server you wish to work with. The command you'll need to run is as follows:
mysqldump -u username -p database > file
Replace the username, database and file parameters with the values that match your database. For instance:
mysqldump -u root -p mydatabase > /home/backups/mybackup.sql
If all goes well, you'll be prompted for the password, and then the backup file will be made.
Note that in the above example, the /home/backups folder must exist. If it doesn't, you'll need to make it first.
Restore Your MySQL Database
Be careful with this, because any existing data will be overwritten. You'll need to do the following:
mysql -u username -p database < file
If we wanted to restore from the file we just made, here's what we'd do:
mysql -u root -p mydatabase < /home/backups/mybackup.sql
Once again, just enter the password, and the database will be restored from the file you supplied.
10. 09. 10
Linking data is similar to importing, but instead of placing a copy of the information into Access, you add a "link" to the external database. If you update the information in the external program, the changes appear in Access as well. Linking is a better choice than importing if you are editing the data with another program, or if you are accessing the data infrequently from your MS Access database. These instructions are for Access 97.
Instructions
Things You'll Need:
Microsoft Access
1
Open or make the MS Access database that you want to link to another database.
2
From the File menu, select Get External Data, then Link Tables.
3
From the Files of Type box, indicate the type of file that is to be linked.
4
Go to the Look In box, and go through the folders and files on your disk until you locate the one that is to be linked.
5
Select that file.
6
Click Link.
7
Provide any information that MS Access requests. For example, you may be questioned to identify tables, provide passwords, etc.
Tips & Warnings
If you delete the icon to a linked table, only the link is deleted, not the table itself.
You can link data from tables that are made in another version of MS Access, from an HTML table, or from programs such as Excel, FoxPro, dBase, or Paradox.
For the link to work, you can't go the external table, or Access won't be able to find it. If the external table is went, you'll need to reestablish the link.
09. 09. 10
FontPark is a fantastic huge database of free fonts—for personal and/or commercial use—that'll work on Windows, Mac, and Linux.
With 70,000 free fonts it can be hard to narrow it down, so FontPark has a bunch of filtering and sorting options so you can browse only the top fonts, for example. You can also search the site if there's something you're looking for in particular. If your typographic gluttony doesn't cap off at 70,000, you can also find fantastic free fonts at DaFont (our take), The League of Movable Type, and Urban Fonts.
