Today, we developed a SQL statement on the test server with phpMyAdmin to import it into the beta database, but the beta server did not have the phpMyAdmin software installed on it, and I saw the process of deleting the data table. Using MySQL command import is certainly not the way, can only be installed on the beta server phpMyAdmin software to be able to import the SQL statement? The SQL statement is as follows, and I just intercepted part of it:
--phpMyAdmin SQL Dump
--Version 3.3.9
--Http://www.phpmyadmin.net
--
--Host:localhost
--Generation Time:dec at 08:44 PM
--Server version:5.0.45
--PHP version:5.2.4
SET sql_mode= "No_auto_value_on_zero";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT * *;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS =@ @CHARACTER_SET_RESULTS * *;
/*!40101 SET @OLD_COLLATION_CONNECTION =@ @COLLATION_CONNECTION * *;
/*!40101 SET NAMES UTF8 * *;
--
--Database: ' cms_convert_5342 '
--
-- --------------------------------------------------------
--
--Table structure for table ' Wp_commentmeta '
--
DROP TABLE IF EXISTS ' Wp_commentmeta ';
CREATE TABLE ' Wp_commentmeta ' (
' meta_id ' bigint unsigned not NULL auto_increment,
' comment_id ' bigint unsigned not NULL default ' 0 ',
' Meta_key ' varchar (255) Default NULL,
' Meta_value ' Longtext,
PRIMARY KEY (' meta_id '),
KEY ' comment_id ' (' comment_id '),
KEY ' Meta_key ' (' Meta_key ')
) Engine=myisam DEFAULT Charset=utf8 auto_increment=1;
--
--Dumping data for table ' Wp_commentmeta '
--