hawkal2k5 asked:


I have a table in a database with about 2000 entries and 3 of the field in the database of all these entries need to be reset to their original value. How could I do this without manually going through all 2000 values and editing them?
I need to reset them to their default values which is just “blank” no value also its only for 3 field in the table not the whole table

mikenku posted video:

Take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin.

Superpappa asked:


Its a hosted account with PHP and phpMyAdmin. The source control is local subversion.
The idea is to easily see relevant differences, and I suspect that for example SQL code backup is not the best way to do that.
How is this better than PHPMyAdmin?
Was thinking of something like XML, or perhaps having just one item pr line.

Dre asked:


P.S. I’m also getting another site with a webhost that provides the tools I need. Unfortunately, none of them seem to provide the proper instructions. How would I set up the site so that it runs on the server provided to me by my webhost and not my localhost? Thanks in advance.

Ganesh I asked:


When I go to my phpmyadmin(mysql manager) I see a table called wp_users in which passwords of all users are stored but they are encrypted(Example: 3khj4k2lk32lkdddlkfk4kl43ljkfkdl but thats npt the real password). So dus anyone know how to decrypt it?

Pop B asked:


I have hundreds of columns of data, each one 9 rows, and I would like to turn each column into a record set in a MySQL database. I have no idea how to do that without typing each one into PHPmyAdmin. Is there some way I could “copy and paste” it into the database?