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

82 views
Skip to first unread message

GTC

unread,
Feb 20, 2016, 10:26:45 AM2/20/16
to 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

unread,
Feb 20, 2016, 9:44:33 PM2/20/16
to 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

unread,
Feb 22, 2016, 7:42:39 PM2/22/16
to 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

unread,
Feb 24, 2016, 5:36:49 AM2/24/16
to 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
Reply all
Reply to author
Forward
0 new messages