Searching through a database with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to use the search feature. First, select the database you want to search… … then click the Search tab. Let’s search the name field for the name John, using the percent sign (%) before and after […]
Running SQL queries on a database with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to run SQL queries on a database. First, select the database you want to run a query on… As demonstrated in another video, you can delete (or drop) a field from a table by […]
Importing databases and tables with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to import databases and tables. First, select the database you want to import. Let’s assume the data in our details table is corrupt, and we want to import a recent backup (or exported copy). Therefore, let’s […]
Deleting a table from a database with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to delete a database table. First, select the database where the table exists. Select the table by checking its checkbox… … then click Drop. Click OK to confirm. That’s it! The table has been […]
Renaming database tables with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to rename a database table. First, select the database where the table exists… … then click the table you want to rename. Click the Operations tab. Under Table Options, in the Rename table to section, enter a […]
Modifying fields in database tables with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to modify existing fields within a database table. First, select the database where the table exists… … then click the table where field exists that you want to modify. Click the Structure tab. Select the […]
Deleting fields from database tables with phpMyAdmin This video assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to delete fields from a database table. First, select the database where the table exists… … then click the table from which you want to remove a field. Click the Structure tab. Select the field […]
How to create remote folders using FileZilla This demo assumes you already have FileZilla running on your computer, and are connected to a remote server. Now let’s learn how to create folders on a remote server. Right click anywhere in the remote server window… … then click Create Directory. Enter a name for your new […]
Setting up a connection in FileZilla’s Site Manager This demo assumes you already have FileZilla running on your computer. Now let’s learn how to setup a connection using Site Manager. Click the Site Manager icon here. With Site Manager you can save remote server login information for multiple sites or servers, and even organize them […]