Programmer's Procedure to Copy a Database Table
Copying a database table is a necessary task when upgrading a client website when one or more tables are missing on the target website. This does not introduce new functionality into the core CMS and does not require changing documentation or program modules. Since this involves changes in the database, this procedure is aimed at the programmer or database administrator.
The general procedure to copy a table from one database to another is the same for every table. If the sql query you need is already saved in the D:\CyThink\coreSMS\sql folder you can skip steps 1 through 7. This is the procedure.
-
Determine the table name.
-
Access phpMyAdmin using the host control panel of the source website: Login >> MySQL Administration >> phpMyAdmin.
-
Click the table name in the list of tables on the left side of the page.
-
Click Export in the row of tabs at the top of the page.
-
Note the option settings. Export: SQL. Structure: Checked. Add DROP TABLE: Checked. Data: Unchecked. Save as file: Checked. Compression: None. Click Go.
-
Save the file in an appropriate local directory such as D:\CyThink\coreSMS\sql.
-
Close the phpmyadmin window. Log out of the Control Panel.
-
Access phpMyAdmin using the host control panel of the target website: Login >> MySQL Administration >> phpMyAdmin.
-
Click the database name at the top of the list of tables.
-
Click SQL in the row of tabs at the top of the page.
-
Browse for the command file using the Browse button in the lower half of the page.
-
Select the file, click Open and then click Go.
-
Examine the results and fix as needed. If copying the code table, be sure the "codecode-codecode" row is present.
-
Close the phpmyadmin window. Log out of the Control Panel.
This procedure is abbreviated and high level. It is documented to prompt the programmer as to the needed steps and is not intended to be a detailed step-by-step procedures.
|
