We have just had the case of having ftp access to a site on a shared hosting LAMP webspace but needed also the database and mainly the database scheme to setup our own development-system for the app. This is actually very straight forward using the following snippet uploaded and executed on the webserver: <?php exec( ’mysqldump [...]
Posts Tagged ‘mySQL’
January 18, 2010 by marco · Leave a Comment
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
January 14, 2009 by marco · Comments Off
Filed under: Snippets, mySQL
Social Tagging: cli • mySQL • php • script • variables
Filed under: Snippets, mySQL
Social Tagging: cli • mySQL • php • script • variables
Case: I was building a CLI script to aggregate data from one MySql database and write results to another MySql database using 2 open db-connections. This way the script’s execution time was in the some-minutes-range… not good! I tried a more effective attempt: I let the CLI script output all necessary statements to drop and [...]
I have just discovered an issue if you store serialized objects into MySql. At first I used fieldtype TEXT. If in this case somebody edited another field of such a record with phpMyAdmin and pushed the save button, the stored object in that record got currupted and the object could not be deserialized and instanciated [...]
October 23, 2008 by marco · Comments Off
Filed under: Snippets, Tools
Social Tagging: mySQL • php • scripts • Tools
Filed under: Snippets, Tools
Social Tagging: mySQL • php • scripts • Tools
I had a bunch of .dbf (source was Lotus Approach) files, at which I wanted to shoot SQL-like queries to generate some meaningful reports. So there were 2 tasks to be accomplished: Read the data into a tool or database and formulate and perform the queries to generate results to base your reports on. As [...]
RSS