I always forget these 2, although I use them quite often. Doh!
Out:
mysqldump -u[user] -p[pass] [db] > [file]
and back in:
mysql -u[user] -p[pass] [db] < [file]
I always forget these 2, although I use them quite often. Doh!
Out:
mysqldump -u[user] -p[pass] [db] > [file]
and back in:
mysql -u[user] -p[pass] [db] < [file]
The driver used is FreeTDS, TDS stands for Tabular Data Stream which is an application layer protocol, used to transfer data between a database server and a client. It was initially developed by Sybase Inc. (that’s where the name of the package comes from, for those curious) and later by Microsoft for their relational SQL databases.
In most cases this should work:
sudo apt-get install php5-sybase freetds-common libsybdb5
but if it doesn’t, you probably need to change the TDS version that is in use by the driver. The configuration file is named freetds.conf, and should be in your /etc/ folder.
There are 2 ways for this:
mssql_connect("exampleServer\\SQLEXPRESS", "user", "password");
Ow, if it still isn’t working, then you have probably forgotten to allow remote connections on your server. From the start menu find and open “SQL Server Surface Area Configuration” then “Surface Area Configuration for Services and Connections”. Find your instance, expand the “Database Engine” tab, select “Remote Connections” and choose the “Using both TCP/IP and Named Pipes” option. After applying, you must restart your instance for the settings to take effect.
For info on TDS versions used in specific MSSQL version you can go here, or just use the direct link and download [MS-TDS].pdf and go to Appendix A. (or just use the newest version, think it’s 8.0 at the moment, it should work fine)
LDAP (Lightweight Directory Access Protocol), in short, is an application protocol used to lookup for information on a server. As far as I figured, it is used mostly for user authorization or (e-mail) address books. The Wikipedia article on LDAP is quite good, so you can get basic info/ideas there.