The change
Edit local httpd.conf or apache.conf or whatever it is named in your case and put the following variable which will export the MY_ENV_DEVEL the variable with 1 as a value.
SetEnv MY_ENV_DEVEL 1
$dev_env = !empty($_SERVER['MY_ENV_DEVEL']) ? 'devel' : 'production';
Simple ini style configuration file
[general]
db.adapter = "PDO_MYSQL"
db.config.host = "localhost"
db.config.username = "root"
db.config.password = ""
db.config.dbname = "test"
$config = new Zend_Config_Ini('./config/config.ini', 'general');
$db = Zend_Db::factory($config->db->adapter, $config->db->config->toArray());
Zend_Db_Table::setDefaultAdapter($db);
$db->setFetchMode(Zend_Db::FETCH_OBJ);
Simple ini style configuration file
[general]
db.adapter = "PDO_MYSQL"
db.config.host = "localhost"
db.config.username = "root"
db.config.password = ""
db.config.dbname = "test"
$config = new Zend_Config_Ini('./config/config.ini', 'general');
$db = Zend_Db::factory($config->db->adapter, $config->db->config->toArray());
Zend_Db_Table::setDefaultAdapter($db);
// depending on the columns of your table modify the $data array
$data = array('full_name' => "Example Name", 'active' => 1, );
$db->insert('some_table', $data);
$db->lastInsertId()
Did you get the following error on your Mac OS ?
The Problem:
Can't move .svn/tmp/entries to .svn/entries: Operation not permitted
The Solution:
cd working_copy
chflags -R nouchg *
Warning: Always make backups.
Convert existing MySQL database from one charset encoding to another
ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE db_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
mysqldump --user=username --password=password --default-character-set=latin1 --compatible=mysql40 dbname > dump.sqlImport database as utf8
mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql
The Problem
svn: Directory .svn containing working copy admin area is missing
Explanation
You have accidentally deleted .svn folder.
Solution
Option #1 Checkout the whole project again
svn co http://yoursvn/project/trunk delme
Option #2 Checkout only specific folder from project
svn co http://yoursvn/project/trunk/data/ delme
mv delme/.svn /local/path/project/data/
Note: 'delme' is a folder that you'll want to delete later after your SVN folder is fixed. This is where the files are being checked out
MySQL fulltext settings
Fulltext search is only available for MyISAM tables and there is a minimal length of the searched word which is determined by ft_min_word_len variable.
To show current MySQL fulltext settings use the following query in mysql console or in phpMyAdmin SQL box.
SHOW VARIABLES LIKE 'ft_%';
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
How to disable strict mode in MySQL 5 Windows XP
Edit /my.ini and look for line
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"replace it with
sql_mode='MYSQL40'
net stop mysql5Update: (2008-04-03):
net start mysql5
mysql_query("SET @@global.sql_mode='MYSQL40'");
Do you have files that contain cyrilic characters ?
I found an old script of mine (from 2004) that I decided to share with you.
http://funcs.org/downloads/cy2lat/cyr2lat.zip
Note:
For Windows users I've created a GUI (Graphic User Interface) so it will be very easy for you.
If you find any bugs or would like to suggest some improvements feel free to contact me.
(contact info can be found in the ZIP file)
Slavi
Sometimes you forgot to add an UNIQUE constraint to a field and you end up having
so many unneeded duplicated records.
My solution is basically the following.
1) Export the table's data
2) Empty the table
3) Set an UNIQUE constraint to a column
4) Reimport data
Here are the details:
This is the most important step, so please pay attention.
1) Exporting the table's data
In phpMyAdmin choose your table
Click -> Export
Click on the following checkboxes (marked in bold are extremely important).
[Structure]
[X] Add IF NOT EXISTS
[Data]
[X] Complete inserts
[X] Extended inserts
[X] Use ignore inserts
I your table is quite big I would suggest you to choose
Compression: (o) "gzipped"
Click the Go button
2) Empty the table
Make sure your export is successful or YOU WILL LOOSE YOUR DATA!!!
Click Empty table and confirm.
3) Set a UNIQUE constraint to a column
Go to Structure tab of your table
Choose the column and click on the U image to make the field UNIQUE
4) Reimport data
Go to Import
Click browse to locate the previously dumped file and then click GO button
Note:
If the file is too big you might have to import the data through ssh.
Upload the YOUR_DATABASE_DUMP.sql.gz
gunzip YOUR_DATABASE_DUMP.sql.gzYou will be prompted for a password and after several minutes you're done.
mysql --user=YOUR_DB_USER -p YOUR_DB_NAME < YOUR_DATABASE_DUMP.sql
Posts
All Comments
