by Johnson Yip
on October 20, 2010
Sometime you accidentally deleted or wrecked a table in phpmyadmin by being careless, so you need to recreate the table, or restore your database in Phymyadmin.
Maybe you need a MySQL table for your web app which need a place to store data like blog posts which is imputed by a user.
The easiest way to create or recreate a table is to use Phpmyadmin table creator found in Phpmyadmin Database table listings.
Using the GUI interface of PhpMyadmin to create tables can also be a good way to learn SQL code since PhpMyAdmin outputs the SQL code used to create the table which you can reuse to create tables on other databases with the SQL command box in PhpMyAdmin
Click Here to Learn how to Create a table in Phpmyadmin
Tagged as:
MySQL database,
phpmyadmin,
phpmyadmin create table,
sql create table,
sql. mysql
by Johnson Yip
on October 20, 2010
Sometimes when you can’t access your website’s cms back-end because something went horribly wrong, messed up a setting or you forgot your password. It may be possible to recover your password or settings by looking in your users table or make a new entry in Phpmyadmin to notify your members that you are having website troubles.
It is very easy to browse, add, and edit entries in your database tables in Phpmyadmin for your MySQL database located on your web hosts server.
Click here to learn how to browse, add, and edit entries in phpmyadmin for your MySQL tables on your Database
Tagged as:
add and edit entries phpmyadmin,
browse database tables phpmyadmin,
phpmyadmin
by Johnson Yip
on October 18, 2010
Executing commands in PhpMyAdmin lets you easily remove junk posts, add entries, make tables, and modify your database quickly if you are good at mySQL commands like
DELETE FROM wp_posts WHERE post_type = "revision"
It can save you a lot of time since you do not have to login to your CMS or forum to make changes to your data base. You can just use the built-in phpmyadmin SQL text box tool.
Click here to learn how to run mySQL commands in phpmyadmin
Tagged as:
database mysql,
phpmyadmin,
queries,
sql commands