Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Edit SQL-file for upload with MySql Administrator

Asked Modified Viewed 2,626 times
P
ponas
P
ponas 10
SUPERADMIN & CREATOR:
www.lhslbandy.com
  • Member, joined since
  • Contributed 59 posts on the community forums.
  • Started 21 threads in the forums
  • Started this discussions
asked
Member

Im trying to upload a swl-script into my database. This doesnt work because my host doesnt include phpmyadmin in their services. Thats the reason why i use MySql Administrator instad. Now the problem is that MySql Administrator can import scripts ment for phpmyadmin.

Can someone please look at this script and changed it so i can upload it with MySql Administrator?


-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 25, 2008 at 08:52 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: esac
--

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

--
-- Table structure for table fusion_nations
--

CREATE TABLE fusion_nations (
  nat_id smallint(5) unsigned NOT NULL auto_increment,
  nat_name varchar(150) NOT NULL,
  nat_pic varchar(200) NOT NULL,
  PRIMARY KEY  (nat_id)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

--
-- Dumping data for table fusion_nations
--

INSERT INTO fusion_nations (nat_id, nat_name, nat_pic) VALUES
(1, 'Sweden', 'images/flags/f-se.gif'),
(2, 'Norway', 'images/flags/f-no.gif'),
(3, 'Finland', 'images/flags/f-fi.gif'),
(4, 'Spain', 'images/flags/f-es.gif'),
(6, 'France', 'images/flags/f-fr.gif'),
(7, 'Argentina', 'images/flags/f-ar.gif'),
(8, 'Uruguay', 'images/flags/f-uy.gif'),
(9, 'Denmark', 'images/flags/f-dk.gif'),
(10, 'Afghanistan', 'images/flags/f-af.gif'),
(11, 'Albania', 'images/flags/f-al.gif'),
(12, 'Algeria', 'images/flags/f-dz.gif'),
(14, 'Andorra', 'images/flags/f-ad.gif'),
(15, 'Australia', 'images/flags/f-au.gif'),
(16, 'Anguilla', 'images/flags/f-ai.gif'),
(17, 'Antigua and Barbuda', 'images/flags/f-ag.gif'),
(19, 'Armenia', 'images/flags/f-am.gif'),
(20, 'Aruba', 'images/flags/f-aw.gif'),
(21, 'Ashmore and Cartier Islands', 'images/flags/f-au.gif'),
(23, 'Austria', 'images/flags/f-at.gif'),
(24, 'Azerbaijan', 'images/flags/f-az.gif'),
(25, 'Bahamas', 'images/flags/f-bs.gif'),
(26, 'Bahrain', 'images/flags/f-bh.gif'),
(27, 'Bangladesh', 'images/flags/f-bd.gif'),
(28, 'Barbados', 'images/flags/f-bb.gif'),
(29, 'Belarus', 'images/flags/f-by.gif'),
(30, 'Belgium', 'images/flags/f-be.gif'),
(31, 'Belize', 'images/flags/f-bz.gif'),
(32, 'Benin', 'images/flags/f-bj.gif'),
(33, 'Bhutan', 'images/flags/f-bt.gif'),
(34, 'Bolivia', 'images/flags/f-bo.gif'),
(35, 'Bosnia and Herzegovina', 'images/flags/f-ba.gif'),
(37, 'Botswana', 'images/flags/f-bw.gif'),
(38, 'Brazil', 'images/flags/f-br.gif'),
(39, 'United Kingdom', 'images/flags/f-uk.gif'),
(40, 'Brunei', 'images/flags/f-bn.gif'),
(41, 'Bulgaria', 'images/flags/f-bg.gif'),
(42, 'Burkina Faso', 'images/flags/f-bf.gif'),
(43, 'Burma (Myanmar)', 'images/flags/f-mm.gif'),
(44, 'Burundi', 'images/flags/f-bi.gif'),
(45, 'Cambodia', 'images/flags/f-kh.gif'),
(46, 'Cameroon', 'images/flags/f-cm.gif'),
(47, 'Canada', 'images/flags/f-ca.gif'),
(48, 'Cape Verde', 'images/flags/f-cv.gif'),
(49, 'Cayman Islands', 'images/flags/f-ky.gif'),
(50, 'Central African Republic', 'images/flags/f-cf.gif'),
(51, 'Chad', 'images/flags/f-td.gif'),
(52, 'Chile', 'images/flags/f-cl.gif'),
(53, 'China', 'images/flags/f-cn.gif'),
(54, 'Christmas Island', 'images/flags/f-cx.gif'),
(56, 'Colombia', 'images/flags/f-co.gif'),
(57, 'Comoros', 'images/flags/f-km.gif'),
(58, 'Congo', 'images/flags/f-cg.gif'),
(60, 'Cook Islands', 'images/flags/f-ck.gif'),
(61, 'Costa Rica', 'images/flags/f-cr.gif'),
(62, 'Cote d'Ivoire', 'images/flags/f-ci.gif'),
(63, 'Croatia', 'images/flags/f-hr.gif'),
(64, 'Cuba', 'images/flags/f-cu.gif'),
(65, 'Cyprus', 'images/flags/f-cy.gif'),
(66, 'Czech Republic', 'images/flags/f-cz.gif'),
(68, 'Djibouti', 'images/flags/f-dj.gif'),
(69, 'Dominica', 'images/flags/f-dm.gif'),
(70, 'Dominican Republic', 'images/flags/f-do.gif'),
(71, 'East Timor', 'images/flags/f-tp.gif'),
(72, 'Ecuador', 'images/flags/f-ec.gif'),
(73, 'Egypt', 'images/flags/f-eg.gif'),
(74, 'El Salvador', 'images/flags/f-sv.gif'),
(75, 'Equatorial Guinea', 'images/flags/f-gq.gif'),
(76, 'Eritrea', 'images/flags/f-er.gif'),
(77, 'Estonia', 'images/flags/f-ee.gif'),
(78, 'Ethiopia', 'images/flags/f-et.gif'),
(79, 'Faroe Islands', 'images/flags/f-fo.gif'),
(80, 'Fiji', 'images/flags/f-fj.gif'),
(81, 'French Guyana', 'images/flags/f-gf.gif'),
(82, 'French Polynesia', 'images/flags/f-pf.gif'),
(83, 'Gabon', 'images/flags/f-ga.gif'),
(84, 'Gambia', 'images/flags/f-gm.gif'),
(85, 'Georgia', 'images/flags/f-ge.gif'),
(86, 'Germany', 'images/flags/f-de.gif'),
(87, 'Ghana', 'images/flags/f-gh.gif'),
(88, 'Greece', 'images/flags/f-gr.gif'),
(89, 'Greenland', 'images/flags/f-gl.gif'),
(90, 'Grenada', 'images/flags/f-gd.gif'),
(91, 'Guadeloupe', 'images/flags/f-gp.gif'),
(92, 'Guam', 'images/flags/f-gu.gif'),
(93, 'Guatemala', 'images/flags/f-gt.gif'),
(95, 'Guinea', 'images/flags/f-gn.gif'),
(96, 'Guinea-Bissau', 'images/flags/f-gw.gif'),
(97, 'Guyana', 'images/flags/f-gy.gif'),
(98, 'Haiti', 'images/flags/f-ht.gif'),
(99, 'Netherlands', 'images/flags/f-nl.gif'),
(100, 'Honduras', 'images/flags/f-hn.gif'),
(101, 'Hungary', 'images/flags/f-hu.gif'),
(102, 'Iceland', 'images/flags/f-is.gif'),
(103, 'India', 'images/flags/f-in.gif'),
(104, 'Indonesia', 'images/flags/f-id.gif'),
(105, 'Iran', 'images/flags/f-ir.gif'),
(106, 'Iraq', 'images/flags/f-iq.gif'),
(107, 'Ireland', 'images/flags/f-ie.gif'),
(109, 'Israel', 'images/flags/f-il.gif'),
(110, 'Italy', 'images/flags/f-it.gif'),
(111, 'Jamaica', 'images/flags/f-jm.gif'),
(112, 'Japan', 'images/flags/f-jp.gif'),
(113, 'Jordan', 'images/flags/f-jo.gif'),
(114, 'Kazakstan', 'images/flags/f-kz.gif'),
(115, 'Kenya', 'images/flags/f-ke.gif'),
(116, 'Kiribati', 'images/flags/f-ki.gif'),
(117, 'Korea, North', 'images/flags/f-kp.gif'),
(118, 'Korea, South', 'images/flags/f-kr.gif'),
(119, 'Kuwait', 'images/flags/f-kw.gif'),
(120, 'Kyrgyzstan', 'images/flags/f-kg.gif'),
(121, 'Laos', 'images/flags/f-la.gif'),
(122, 'Latvia', 'images/flags/f-lv.gif'),
(123, 'Lebanon', 'images/flags/f-lb.gif'),
(124, 'Lesotho', 'images/flags/f-ls.gif'),
(125, 'Liberia', 'images/flags/f-lr.gif'),
(126, 'Libya', 'images/flags/f-ly.gif'),
(127, 'Liechtenstein', 'images/flags/f-li.gif'),
(128, 'Lithuania', 'images/flags/f-lt.gif'),
(129, 'Luxembourg', 'images/flags/f-lu.gif'),
(130, 'Macedonia', 'images/flags/f-mk.gif'),
(131, 'Madagascar', 'images/flags/f-mg.gif'),
(132, 'Malawi', 'images/flags/f-mw.gif'),
(133, 'Malaysia', 'images/flags/f-my.gif'),
(134, 'Maldives', 'images/flags/f-mv.gif'),
(135, 'Mali', 'images/flags/f-ml.gif'),
(136, 'Malta', 'images/flags/f-mt.gif'),
(137, 'Marshall Islands', 'images/flags/f-mh.gif'),
(138, 'Martinique', 'images/flags/f-mq.gif'),
(139, 'Mauritania', 'images/flags/f-mr.gif'),
(140, 'Mauritius', 'images/flags/f-mu.gif'),
(141, 'Mexico', 'images/flags/f-mx.gif'),
(142, 'Micronesia', 'images/flags/f-fm.gif'),
(143, 'Moldova', 'images/flags/f-md.gif'),
(144, 'Monaco', 'images/flags/f-mc.gif'),
(145, 'Mongolia', 'images/flags/f-mn.gif'),
(146, 'Montenegro', 'images/flags/f-me.gif'),
(147, 'Montserrat', 'images/flags/f-ms.gif'),
(148, 'Morocco', 'images/flags/f-ma.gif'),
(149, 'Mozambique', 'images/flags/f-mz.gif'),
(150, 'Namibia', 'images/flags/f-na.gif'),
(151, 'Nauru', 'images/flags/f-nr.gif'),
(152, 'Nepal', 'images/flags/f-np.gif'),
(153, 'Netherlands Antilles', 'images/flags/f-an.gif'),
(154, 'New Caledonia', 'images/flags/f-nc.gif'),
(155, 'New Zealand', 'images/flags/f-nz.gif'),
(156, 'Nicaragua', 'images/flags/f-ni.gif'),
(157, 'Niger', 'images/flags/f-ne.gif'),
(158, 'Nigeria', 'images/flags/f-ng.gif'),
(159, 'Niue', 'images/flags/f-nu.gif'),
(160, 'Norfolk Island', 'images/flags/f-nf.gif'),
(162, 'Northern Mariana Islands', 'images/flags/f-mp.gif'),
(163, 'Oman', 'images/flags/f-om.gif'),
(164, 'Pakistan', 'images/flags/f-pk.gif'),
(165, 'Palau', 'images/flags/f-pw.gif'),
(166, 'Palestine', 'images/flags/f-ps.gif'),
(167, 'Panama', 'images/flags/f-pa.gif'),
(168, 'Papua New Guinea', 'images/flags/f-pg.gif'),
(169, 'Paraguay', 'images/flags/f-py.gif'),
(170, 'Peru', 'images/flags/f-pe.gif'),
(171, 'Philippines', 'images/flags/f-ph.gif'),
(172, 'Poland', 'images/flags/f-pl.gif'),
(173, 'Portugal', 'images/flags/f-pt.gif'),
(174, 'Qatar', 'images/flags/f-qa.gif'),
(175, 'Romania', 'images/flags/f-ro.gif'),
(176, 'Russia', 'images/flags/f-ru.gif'),
(177, 'Saint Kitts and Nevis', 'images/flags/f-kn.gif'),
(178, 'Saint Lucia', 'images/flags/f-lc.gif'),
(179, 'Saint Pierre and Miquelon', 'images/flags/f-pm.gif'),
(180, 'Saint Vincent and the Grenadines', 'images/flags/f-vc.gif'),
(181, 'Samoa', 'images/flags/f-ws.gif'),
(182, 'San Marino', 'images/flags/f-sm.gif'),
(183, 'Sao Tome and Principe', 'images/flags/f-st.gif'),
(184, 'Saudi Arabia', 'images/flags/f-sa.gif'),
(185, 'Senegal', 'images/flags/f-sn.gif'),
(186, 'Serbia', 'images/flags/f-rs.gif'),
(187, 'Seychelles', 'images/flags/f-sc.gif'),
(188, 'Sierra Leone', 'images/flags/f-sl.gif'),
(189, 'Singapore', 'images/flags/f-sg.gif'),
(190, 'Slovakia', 'images/flags/f-sk.gif'),
(191, 'Slovenia', 'images/flags/f-si.gif'),
(192, 'Solomon Islands', 'images/flags/f-sb.gif'),
(193, 'Somalia', 'images/flags/f-so.gif'),
(194, 'South Africa', 'images/flags/f-za.gif'),
(196, 'Sri Lanka', 'images/flags/f-lk.gif'),
(198, 'Sudan', 'images/flags/f-sd.gif'),
(199, 'Suriname', 'images/flags/f-sr.gif'),
(200, 'Swaziland', 'images/flags/f-sz.gif'),
(201, 'Switzerland', 'images/flags/f-ch.gif'),
(202, 'Syria', 'images/flags/f-sy.gif'),
(203, 'Taiwan', 'images/flags/f-tw.gif'),
(204, 'Tajikistan', 'images/flags/f-tj.gif'),
(205, 'Tanzania', 'images/flags/f-tz.gif'),
(206, 'Thailand', 'images/flags/f-th.gif'),
(207, 'Togo', 'images/flags/f-tg.gif'),
(208, 'Tonga', 'images/flags/f-to.gif'),
(209, 'Trinidad and Tobago', 'images/flags/f-tt.gif'),
(210, 'Tunisia', 'images/flags/f-tn.gif'),
(211, 'Turkey', 'images/flags/f-tr.gif'),
(212, 'Turkmenistan', 'images/flags/f-tm.gif'),
(213, 'Turks and Caicos Islands', 'images/flags/f-tc.gif'),
(214, 'Tuvalu', 'images/flags/f-tv.gif'),
(215, 'Uganda', 'images/flags/f-ug.gif'),
(216, 'Ukraine', 'images/flags/f-ua.gif'),
(217, 'United Arab Emirates', 'images/flags/f-ae.gif'),
(218, 'United States', 'images/flags/f-us.gif'),
(220, 'Uzbekistan', 'images/flags/f-uz.gif'),
(221, 'Vanuatu', 'images/flags/f-vu.gif'),
(222, 'Vatican City', 'images/flags/f-va.gif'),
(223, 'Venezuela', 'images/flags/f-ve.gif'),
(224, 'Vietnam', 'images/flags/f-vn.gif'),
(225, 'Yemen', 'images/flags/f-ye.gif'),
(226, 'Yugoslavia', 'images/flags/f-yu.gif'),
(227, 'Zambia', 'images/flags/f-zm.gif'),
(228, 'Zimbabwe', 'images/flags/f-zw.gif'),
(232, 'Ã…land Island', 'images/flags/f-ax.gif'),
(233, 'Angola', 'images/flags/f-ao.gif'),
(235, 'Bouvet Island', 'images/flags/f-bv.gif');
Edited by ponas on 28-06-2008 16:18,
0 replies
There are no post found.

Labels

None yet

Statistics

  • Views 0 views
  • Posts 0 posts
  • Votes 0 votes
  • Topic users 1 member

1 participant

P
P
ponas 10
SUPERADMIN & CREATOR:
www.lhslbandy.com
  • Member, joined since
  • Contributed 59 posts on the community forums.
  • Started 21 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet