Import sql from another pc

[elena_leo]

Hi,

Could you please help me??? I tried to import a sql file from another pc into mine and I cant...

The message is:

"error
it seems there is an error
ERROR: unknown error @ 165
STR: 5.1.
SQL: -- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- system: localhost
-- date of creation: 15 march 2012, 12:50
-- version server: 5.1.41
-- version PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";# Η MySQL returned an empty result set"

What is wrong?

Thanks...

[Altrea]

I tried to import a sql file from another pc into mine

How? Could be an important information... maybe...

[elena_leo]

Yes, ... sorry...

I have installed in my pc xampp 1.7.3
I worked in another pc using the same xampp (they gave me the installing file of xampp), and i created in a localhost basis a site (by using joomla).
I export the sql file of my site together with the htdocs of this site, and I paste all the files of httdocs to mine.
When I tried to import the sql file, the above message came out...

Is that ok?

there is this indication at the end of the page error "#1046 - No database selected"

[anselm]

Hi,

there is this indication at the end of the page error "#1046 - No database selected"

are the next lines eq

/*!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: `MyDatabase`
--
-- --------------------------------------------------------
--
-- Table structure for table `MyTable`
--
CREATE TABLE IF NOT EXISTS `MyTable` (.......

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

insert the follwoing 2 lines after Database: `MyDatabase`

CREATE DATABES IF NOT EXISTS `MyDatabase`;
USE `MyDatabase`;

Best Regards

[Altrea]

CREATE DATABES IF NOT EXISTS `MyDatabase`;

CREATE DATABASE IF NOT EXISTS `MyDatabase`;

[anselm]

Hi,

CREATE DATABASE IF NOT EXISTS `MyDatabase`;

thanks Altrea. Written too quick....

[suepx19]

There is a simple way, try "Navicat for MySQL". export\import is so easy.