mysql: import csv data
by prettyscripts on 2011-12-16 10:47:00 • Leave a comment »
there are a few ways to to it. here's a solution using load data.
load data local infile '/path/to/csvfile'
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
[ignore 1 lines]
[(column_1, @dummy, column_2,...)]
notes
line 5: t… more »
blogger to b2evo
by prettyscripts on 2010-02-09 10:55:24 • Leave a comment »
detail instruction on how to export data from blogger and import into b2evolution.
i haven't tried it yet but this link will be handy when i need to. more »
PuTTY: import and export settings
by prettyscripts on 2009-12-18 01:42:52 • Leave a comment »
putty does not offer functions to import and export settings. settings are saved in the registry and are imported and exported manually.exportopen registrylocate HKEY_CURRENT_USER\Software\SimonTathamfile > export, save the filecopy this f… more »
symfony: import sfGuardUser data
by prettyscripts on 2009-07-03 13:42:43 • Leave a comment »
since i need to run 'symfony propel:build-all-load' constantly while developing a symfony project, to save myself from creating users for sfGuard plugin everytime it’s run, data from related table were dumped then saved as fixture data so that they are a… more »
symfony: database to fixture data
by prettyscripts on 2009-05-30 14:33:00 • Leave a comment »
while developing a symfony project, it's usually required to rebuild database and reload data constantly with 'symfony doctrine:build-all' or 'symfony doctrine:build-all-load' constantly. when this is run, test data are wiped. the easy way is to have i… more »
Tags: data, database, dump, export, fixtures, framework, import, symfony
Affiliates
©2012 by prettyscripts.• powered by b2evolution • skin by prettyscripts