Import sql from another pc

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Import sql from another pc

Postby elena_leo » 15. March 2012 15:55

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...
elena_leo
 
Posts: 5
Joined: 02. March 2012 13:15
Operating System: windows 7 home premioum

Re: Import sql from another pc

Postby Altrea » 15. March 2012 16:50

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

How? Could be an important information... maybe...
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Import sql from another pc

Postby elena_leo » 15. March 2012 16:59

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"
elena_leo
 
Posts: 5
Joined: 02. March 2012 13:15
Operating System: windows 7 home premioum

Re: Import sql from another pc

Postby anselm » 15. March 2012 17:17

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
anselm
 

Re: Import sql from another pc

Postby Altrea » 15. March 2012 17:53

anselm wrote:CREATE DATABES IF NOT EXISTS `MyDatabase`;

CREATE DATABASE IF NOT EXISTS `MyDatabase`;
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Import sql from another pc

Postby anselm » 15. March 2012 18:05

Hi,
CREATE DATABASE IF NOT EXISTS `MyDatabase`;

thanks Altrea. Written too quick....
anselm
 

Re: Import sql from another pc

Postby suepx19 » 09. August 2012 16:49

There is a simple way, try "Navicat for MySQL". export\import is so easy.
http://ebubbleumbrella.com
suepx19
 
Posts: 1
Joined: 07. August 2012 03:03
Operating System: Windows XP


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 11 guests