what to do with different phpMyAdmin versions

[Kevv3]

Hey,

At my computer I have a newer version of phpMyAdmin than the one on x10hosting.
So when I'm making and testing my website with database on my own computer, I can't upload my database to my online databases. Is there a way to do so? even with a different version? :s because the online phpMyAdmin gives an error when I upload from a newer version.

 

[Jake]

well what are you uploading? sql syntax is the same no matter what version of phpmyadmin you use.

 

[Kevv3]

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 17 Apr 2006 om 14:36
-- Server versie: 5.0.18
-- PHP Versie: 4.2.3
--
-- Database: `gezinsbond`
--
CREATE DATABASE `gezinsbond` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE gezinsbond;

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

--
-- Tabel structuur voor tabel `kalender`
--

CREATE TABLE `kalender` (
`kal_nr` int(11) NOT NULL auto_increment,
PRIMARY KEY (`kal_nr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `kalender`
--


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

--
-- Tabel structuur voor tabel `submenu_items`
--

CREATE TABLE `submenu_items` (
`item_nr` int(4) NOT NULL auto_increment,
`item_nm` varchar(29) NOT NULL,
`item_title` varchar(29) NOT NULL,
`item_headpage` varchar(15) NOT NULL,
PRIMARY KEY (`item_nr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Gegevens worden uitgevoerd voor tabel `submenu_items`
--

INSERT INTO `submenu_items` VALUES (1, 'Algemene Diensten', 'Algemene Diensten', 'diensten');
INSERT INTO `submenu_items` VALUES (2, 'Kinderoppas', 'Kinderoppas', 'diensten');
INSERT INTO `submenu_items` VALUES (3, 'Verminderingskaarten', 'Verminderingskaarten', 'diensten');
INSERT INTO `submenu_items` VALUES (4, 'Gezinsspaarkaart', 'Gezinsspaarkaart', 'diensten');
INSERT INTO `submenu_items` VALUES (5, 'GSM kaarten', 'GSM kaarten', 'diensten');
INSERT INTO `submenu_items` VALUES (6, 'Filmtickets', 'Filmtickets', 'diensten');


That's what I get with export in my phpMyAdmin on my computer. How and where should I import that to my online phpMyAdmin ??

 

[lambada]

I had a similar problem with an old host.
It was caused by the "
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;" part - it caused an error and to this day i'm not sure why it happend. i'm not sure if it would be the same in this one though. Try downloading the same version of phpMyAdmin that x10 has, you won't lose any database data and it is almost guarrenteed to work with the x10 one.