Saturday, February 20, 2016

Re: [google-cloud-sql-discuss] Export my SQL DB / Import to CloudSQL....HELP!!!!

On the import screen, click on "Advanced settings" and enter the database name.
Alternatively, uncomment the "- USE `gtc_wrdp1`;' line in the import file.

On Sat, Feb 20, 2016 at 7:26 AM GTC <socialmedia@gpatech.org> wrote:
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`

--
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-discuss+unsubscribe@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.

--
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-discuss+unsubscribe@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.

No comments:

Post a Comment