Kategoriarkiv: SQL

sql backup and restore

Udgivet den juni 12, 2003 af black

dump the database with mysqldump: mysqldump -A -a -p > [FILE] store it, move it to the new server or do whatever is needed… insert the table by starting the mysql client: mysql -p and run the file with the … Læs resten →

Udgivet i SQL | Skriv en kommentar

SQL backup and restore

Udgivet den juni 12, 2003 af Brian Lund Klint

dump the database with mysqldump: mysqldump -A -a -p > [FILE] store it, move it to the new server or do whatever is needed… insert the table by starting the mysql client: mysql -p and run the file with the … Læs resten →

Udgivet i Knowledge Base, SQL | Skriv en kommentar

Extract all mysql queries from your sourcecode

Udgivet den juni 9, 2003 af mike

cat /usr/local/apache2/inc/* | grep query | perl -lne ‘ s/^\s+//; print;’ > queries

Udgivet i Knowledge Base, Old Base, Shellscript, SQL | Skriv en kommentar

How to search in sql databases.

Udgivet den maj 16, 2003 af Valdimirr

To find a cell contain a specific word you can use the following line in sql. “select * from tabel where felt like \”%$variable%\” order by felt” // Vladimirr – Vladimirr.dk

Udgivet i Knowledge Base, Lamp, Old Base, SQL | Skriv en kommentar