Moving Sql Database

[Freejoy]

Hi,

I'm trying to move my database to another server.

I'm new at sql. I've so far downloaded the database to a wordpad file on my desktop from the old server. When I try to import it to the new server sql I get the error that's it's to large (Max: 2,048KiB) the file I'm moving is about 2100 ...little to much I guess.

I then tried gziping it and importing it, but then get the error: (You attempted to load file with unsupported compression (application/gzip). Either support for it is not implemented or disabled by your configuration.)

How can I import it?

Thanks

[Nick]

Do you have phpMyAdmin access to this database? I know phpMyAdmin offers many download formats, including pre-compressed formats.

[Freejoy]

yes, I have access. But don't know much about how to use it.

[Nick]

When you log into phpMyAdmin and select a DB for use, you should see an option to "Export Database". Look through the options (they have .txt, .sql, .gzip, etc) and select one to download. Then on your new server you go to the same area, expect click "Import Database" and use the file you downloaded.

[longneck]

possibility- that won't work. he already said that the target server has gzip support disabled.

freejoy- just open the file in notepad or wordpad, and use copy-and-paste to split the file in half. just make sure to do it between statements.

[Freejoy]

So, you split it into two smaller files?


Here's some of the database, I would split it where I have it highlighted in red?

  `username` varchar(60) NOT NULL default '',
  `ordernum` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `livehelp_qa`
-- 


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

-- 
-- Table structure for table `livehelp_questions`
-- 

CREATE TABLE `livehelp_questions` (
  `id` int(10) NOT NULL auto_increment,
  `department` int(10) NOT NULL default '0',
  `ordering` int(8) NOT NULL default '0',
  `headertext` text,
  `fieldtype` varchar(30) NOT NULL default '',
  `options` text,
  `flags` varchar(60) NOT NULL default '',
  `module` varchar(60) NOT NULL default '',
  `required` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `department` (`department`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `livehelp_questions`
-- 

INSERT INTO `livehelp_questions` (`id`, `department`, `ordering`, `headertext`, `fieldtype`, `options`, `flags`, `module`, `required`) VALUES 
(1, 1, 0, 'E-mail:', 'email', '', '', 'leavemessage', 'Y'),
(2, 1, 0,

Is that what you mean by spliting it "between statments"?

[longneck]

no, definitely not there. a semicolon (;) is at the end of a statement. so split it right after a semicolon.

[Freejoy]

Splitting it right after a semicolon worked perfect. Thank you