How to change password using phpMyAdmin.
If you can’t access your WordPress administration panel or having password problem, try change your password using phpMyAdmin.
1. Login to your web hosting administration control panel.
2. Click on MySQL administration.
3. Click on phpMyAdmin
4. Click on the wp_user on your database
5. Click on the Pen icon or edit button. […]
I have a bunch of old paths like ./data/test_data/070608_SLXA-EAS20_FC5459/… stored in the processing table of my Postgres DB. I want to update the filesystem paths (file_path column) to /home/solexa/solexa_datasets/070608_SLXA-EAS20_FC5459/… using the Postgres replace() function.
“UPDATE processing SET file_path = replace(file_path, ‘./data/test_data/’, ‘/home/solexa/solexa_datasets/’) WHERE file_path LIKE ‘%./data/test_data%’;”
The same can also be done with regexp_replace() if better suited.
I found a very useful tool today - the Data Generator. It generates large volumes of random, custom data for use in testing software. The tool is a free download, and can generate data in the following formats:
HTML
Excel
XML
CSV
SQL
There is an online demo available that is limited to 200 results. Click here to find out more…
How to delete comments using phpMyAdmin.
1. Login to your web hosting administration control panel.
2. Click on MySQL administration.
3. Click on phpMyAdmin.
4. Click on the wp_comments on your database
5. Delete the comment. Or you can Edit the comment from phpMyAdmin.
NOTICE: Administration panel design may look different from your hosting company web site. But […]
I’ve always wanted to write my own simple shell in php. Call me a glutin for punishment, but it seems like something that a lot of people could use to be able to do… If your web app had a command line interface for various things… like looking up stats, or users, or suspending […]
Langsung aja, aku anggap udah tahu semua apa itu XAMPP ya, kalo ada yg belum tahu, XAMPP itu bundel aplikasi yg terdiri dari Apache Web Server, MySQL, Perl beserta semua modul2nya, dibuat untuk memudahkan kita menginstall dan mengkonfigurasinya, tinggal install/extract dan semuanya langsung jalan.
XAMPP berguna untuk menguji coba WordPress blog kita di komputer lokal sebelum […]
Binary logs is how mysql keeps track of what changed in the databases. While it is recommended (in case you want to recover the database ) and sometimes even required ( if you want to replicate the db ) to keep such logs if you have a server where the database changes frequently those logs […]
Last Friday, I had to run some complicated SQL queries at work. I was dealing with 300k rows of history items that I had to select based on an aggregate function. Unfortunately, WHERE clauses cannot contain the result of an aggregate function. Having clauses are like where clauses, but they’re applied last, […]
How do you create an RSS feed for a web page that does not have one? you use Dapper. That’s what I did with the Oracle database 10gR2 search result page. I used the Dapper generated RSS feed for this page in my oradoc Ubiquity command.
John already had an RSS feed for the 11g documentation […]