Phpld Mysql Database Import

midlandi · 04-10-2007, 07:14 PM

Dont know if anyone can help?

Im trying to import directory database from one site to another.
The problems i have are..

Both mysql versions are different
Bothe phpld versions are differnt ie v2 and v3

Am i on a no hope road?...or cn this be done?

misterx · 04-10-2007, 07:19 PM

Open your databases and compare all table fields. If they are the same you can import items with no problem.

jumpenjuhosaphat · 04-10-2007, 07:29 PM

The best thing to do would probably test it and see. You should be able to import the table if it's a pretty basic table, most tables are. If the db file contains functions that aren't available in your version of MySQL, then you might have a problem. But, the import file should just be a text file, so you won't have any issues as far as that is concerned.

pelinga · 05-06-2007, 03:21 PM

you can use " premiumSoft navicat"
it's a great tool

midlandi · 05-06-2007, 03:51 PM

Quote:

Originally Posted by pelinga

you can use " premiumSoft navicat"
it's a great tool

Do you have a link for this?

dre · 05-06-2007, 04:20 PM

Google found: http://www.navicat.com/

detoam · 05-06-2007, 04:25 PM

If You are importing the db just to add the categories and the links You have than You don't have to worry. I do that all the time with my directories. I just changed all of my directories from 456 categories to 700. If You are importing the settings and all that than I really don't know. I can explain in a bit better detail how I do that if You'd like.

midlandi · 05-06-2007, 04:25 PM

Ah, not what i was looking for.
The databases can be imported easily enough, what the problem is that the versions of the programmes are different and therefore not compatable to do this way.

detoam · 05-06-2007, 04:40 PM

Okay got it. For that You might want to ask the PHPLD. I have posted a question there asking if and how it can be done.

midlandi · 05-06-2007, 04:45 PM

Yeah, i have done that already they say it cant be done

robmac · 06-04-2007, 10:02 AM

i would contact PHPLD as it is possible to import diff sql and diff phpld versions

04-10-2007, 07:14 PM	#1
midlandi iWEBTOOL Moderator Contributor Join Date: Oct 2006 Posts: 2,172	Phpld Mysql Database Import Dont know if anyone can help? Im trying to import directory database from one site to another. The problems i have are.. Both mysql versions are different Bothe phpld versions are differnt ie v2 and v3 Am i on a no hope road?...or cn this be done? __________________ Webmaster Resources & Forums SubmitterBot - Semi-automatic directory submission tool

04-10-2007, 07:19 PM	#2
misterx Junior Member Join Date: Mar 2007 Posts: 92	Re: Phpld Mysql Database Import Open your databases and compare all table fields. If they are the same you can import items with no problem. __________________ █ Affordable Web Hosting - 30 days money back GUARANTEE ! █ Free web directory

04-10-2007, 07:29 PM	#3
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Phpld Mysql Database Import The best thing to do would probably test it and see. You should be able to import the table if it's a pretty basic table, most tables are. If the db file contains functions that aren't available in your version of MySQL, then you might have a problem. But, the import file should just be a text file, so you won't have any issues as far as that is concerned. __________________ Storage Sheds Lost Forum

05-06-2007, 03:21 PM	#4
pelinga Member Join Date: May 2007 Posts: 125	Re: Phpld Mysql Database Import you can use " premiumSoft navicat" it's a great tool __________________ Lisisoft::Panload::About-Recipes Calculate Page Rank

05-06-2007, 04:20 PM	#6
dre wo0h0o Join Date: Dec 2005 Location: Birmingham, UK Posts: 457	Re: Phpld Mysql Database Import Google found: http://www.navicat.com/ __________________ Scrizzle.com - Dre's Blog Enjoy Yourself! SEOContest2008 Myspace Proxy

05-06-2007, 04:25 PM	#7
detoam Junior Guru Join Date: Feb 2007 Location: Canada Posts: 663	Re: Phpld Mysql Database Import If You are importing the db just to add the categories and the links You have than You don't have to worry. I do that all the time with my directories. I just changed all of my directories from 456 categories to 700. If You are importing the settings and all that than I really don't know. I can explain in a bit better detail how I do that if You'd like. __________________ Web hosting - with a choice of server location. Link trading

05-06-2007, 04:25 PM	#8
midlandi iWEBTOOL Moderator Contributor Join Date: Oct 2006 Posts: 2,172	Re: Phpld Mysql Database Import Ah, not what i was looking for. The databases can be imported easily enough, what the problem is that the versions of the programmes are different and therefore not compatable to do this way. __________________ Webmaster Resources & Forums SubmitterBot - Semi-automatic directory submission tool

05-06-2007, 04:40 PM	#9
detoam Junior Guru Join Date: Feb 2007 Location: Canada Posts: 663	Re: Phpld Mysql Database Import Okay got it. For that You might want to ask the PHPLD. I have posted a question there asking if and how it can be done. __________________ Web hosting - with a choice of server location. Link trading

05-06-2007, 04:45 PM	#10
midlandi iWEBTOOL Moderator Contributor Join Date: Oct 2006 Posts: 2,172	Re: Phpld Mysql Database Import Yeah, i have done that already they say it cant be done __________________ Webmaster Resources & Forums SubmitterBot - Semi-automatic directory submission tool

06-04-2007, 10:02 AM	#11
robmac Smurf Join Date: Jun 2007 Posts: 13	Re: Phpld Mysql Database Import i would contact PHPLD as it is possible to import diff sql and diff phpld versions __________________ Free Site submissions Service Nintendo snes gaming site FREE

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL database into server	alampuri	MySQL	2	04-05-2007 06:56 PM
eCommerce with XML or CVS import	Katey	Tools & Software	0	09-17-2006 06:27 PM
Remotely Accessing MySQL Database?	compuXP	MySQL	4	08-31-2006 05:05 AM
phpLD Network - Submit your phpLD script driven directory	Vegabond	Your directory	2	08-05-2006 09:38 PM
Import Kewyord List tool	chtrapp	Search Engine Optimization (SEO)	3	07-02-2006 10:00 PM