Export my SQL DB / Import to CloudSQL....HELP!!!!

瀏覽次數:82 次
跳到第一則未讀訊息

GTC

未讀,
2016年2月20日 上午10:26:452016/2/20
收件者:Google Cloud SQL discuss
this is my error: 

 mysql_query No database selected (CREATE TABLE IF NOT EXISTS `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, `country_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1)


this is what i have in my dump: 

-- phpMyAdmin SQL Dump
-- version 4.0.10.7
--
-- Host: localhost
-- Generation Time: Feb 20, 2016 at 07:22 AM
-- Server version: 5.5.45-cll-lve
-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Create Database: `gtc_wrdp1`;
-- USE `gtc_wrdp1`;

-- --------------------------------------------------------

--
-- Table structure for table `wp_aiowps_events`

Vadim Berezniker

未讀,
2016年2月20日 晚上9:44:332016/2/20
收件者:Google Cloud SQL discuss
On the import screen, click on "Advanced settings" and enter the database name.
Alternatively, uncomment the "- USE `gtc_wrdp1`;' line in the import file.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9b8f5111-ef66-4ece-870d-a928219b8ea3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

paynen

未讀,
2016年2月22日 晚上7:42:392016/2/22
收件者:Google Cloud SQL discuss
This seems like not as much of a useful discussion forum thread as it is an error output. I highly recommend that you post such a thread over at Stack Overflow or at Server Fault since this forum is meant for discussion, not for specific-issue technical support, which is what Stack Exchange sites were designed for. You'll have much more success posting there.

G.P.A. Tech Center

未讀,
2016年2月24日 清晨5:36:492016/2/24
收件者:google-cloud...@googlegroups.com
thank you!

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/t4389--rxiU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p3LM%2BC6pQbbF5xWCAPmjcJVCN8o12%2BrTwF9uervnPZZ1A%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--
Aisha Lewis
--
G.P.A. Tech Center, Inc.
P: 913.915.8388
F: 866.531.4979
E: ques...@gpatech.org
W: http://www.gpatech.org
回覆所有人
回覆作者
轉寄
0 則新訊息