xoops forums

adium

Just popping in
Posted on: 2009/8/2 10:40
adium
adium (Show more)
Just popping in
Posts: 99
Since: 2005/1/18
#1

Better way to working with and managing SQL databases?

You know those modules that you want like 1,000 entries in it, for example a links section, and you have to sit there and enter every single one using the submit.php page?

I have found a better way, using a program (called Navicat) that lets me export my SQL table into an excel file.... or place all my data into an excel file then import it. Problem is, that it only imports by deleting the old table then making a new one. Causing whatever uses that table to be unavailable for the time period you need to upload the new database. This program also limits me to using 255 characters per cell. For a links section, its not a big deal, but for forum entries or blog posts it can create a problem.

I am wondering if anyone uses something similar. I would absolutely love something that functions like excel but works directly with the database online so there is no upload/download crap. Another annoying feature with Navicat is that it doesn't include the column names in the table so you have to type in each name manually before you can import it.

For links and downloads modules this program is great..., but I'm still looking for a little more control.

iHackCode

Module Developer
Posted on: 2009/8/2 14:08
iHackCode
iHackCode (Show more)
Module Developer
Posts: 1036
Since: 2004/6/29
#2

Re: Better way to working with and managing SQL databases?

i first used MS Access with odbc and linked the tables but i couldn't change the schema.

then i started using SQLyog.

now i'm trying out heidiSQL.

CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

dbman

Friend of XOOPS
Posted on: 2009/8/2 15:01
dbman
dbman (Show more)
Friend of XOOPS
Posts: 172
Since: 2005/4/28
#3

Re: Better way to working with and managing SQL databases?

Try Toad for MySQL:
http://www.toadsoft.com/toadmysql/Overview.htm

I've tried just about every database client there is and this has the most features I've seen yet. In particular the file to database import is impressive.

ghia

Community Support Member
Posted on: 2009/8/2 20:10
ghia
ghia (Show more)
Community Support Member
Posts: 4954
Since: 2008/7/3 1
#4

Re: Better way to working with and managing SQL databases?

I do all the needed things with phpMyAdmin.