Search DaniWeb - navicat

Re: navicat 16 Years Ago by fobos ryan311, First of all you dont create tables in navicat, you create mysql tables using navicat. Well im gonna break this down for… , jill. 5. Save the document as you like 6. Open navicat, and make sure that it is connected to the mysql… navicat 16 Years Ago by ryan311 hi how to create a table in navicat? Re: navicat 13 Years Ago by RE:MATIN i want to use navicat for my database how can i use pls help me explain step by step i am a beginner navicat questions 14 Years Ago by teedoff Not sure if many ppl here use navicat, but I am somewhat confused by the … cfm templates. Now I realize, since I have navicat on my laptop as well as my desktop, that…as well, but when I view my tables in navicat, shouldnt they be the latest version FROM the … didnt show up when I viewed the table with navicat. Do I need to manually "get"… Re: navicat questions 14 Years Ago by teedoff …the reply. I actually have two connections in navicat set up with my remote db server that are… localhost and remote server. So when I open navicat here on my desktop, it might show 1555 …can go look on my desktop and open navicat and it doesn't show the new records… records. Even though both instances of navicat are connected to the remote DB server. navicat, MySQLand import wizard 14 Years Ago by teedoff I am new to MySQL and navicat as well. I have been creating a database in Access … them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to save… Access on the pc at work, and I dont have Navicat on my laptop. Complicated I know. Anyway, the first time… Re: navicat questions 14 Years Ago by pritaeas I use navicat too. If your connections are the same at work and … Re: navicat questions 14 Years Ago by pritaeas You would need some synchronization scheme. If you want to do it with navicat, it has a data synchronization option. Re: navicat questions 14 Years Ago by Ericklewis Hi I'm new to this forum, I'm curious to know if anyone has ever experienced Navicat loosing all databases and or connections??? Thanks Erick Re: navicat, MySQLand import wizard 14 Years Ago by pritaeas What is in Navicat's log at the bottom of the import wizard ? Can you post all the lines that are in there ? Re: navicat, MySQLand import wizard 14 Years Ago by teedoff … 2 missing. When I do an import from Access to Navicat, I get two errors that say 1406 data too long… Re: navicat, MySQLand import wizard 14 Years Ago by teedoff Nevermind. lol I figured it out! I saw the design table option in navicat and then changed the type to "longtext".. Then ran the import wizard and the last 2 records were added! Thanks so much for all your help! navicat and foreign keys and restraints 14 Years Ago by teedoff Hi I am using Navicat and have two tables that have a one to many … and is supposed to be the foreign key in rlbbulbs. Navicat has a way of creating foreign keys, which I went… Re: navicat and foreign keys and restraints 14 Years Ago by pritaeas I tried to add one in Navicat, however I get a different error. It could be that you have no rights to create this, but it is hard to say. I'd contact Navicat support if I were you. Normally they are quite helpful. Navicat only importing 72% of file. Why? 13 Years Ago by acakaliman Hey all, I'm new-ish at MySQL and Navicat. I'm trying to import a file with about 1.…16 million records and Navicat keeps "working" (I see the timer moving) but… Re: navicat and foreign keys and restraints 14 Years Ago by teedoff Hi pritaeas, I guess I will have to contact navicat support. Their help system is not very helpful with this … Re: Navicat only importing 72% of file. Why? 13 Years Ago by pritaeas Did you contact Navicat support about this ? Navicat 7.x for Mac (and also Win/Linux) 18 Years Ago by selowitch I'm not terribly happy with the new release of Navicat for which I paid a $49.99 fee to upgrade. … Re: Free Navicat Equivilant? 17 Years Ago by kenmurd Navicat is worth every cent you spend buying it. Most useful adddition to a PHP & MySQL developers toolbox. Give it a try. Re: navicat 16 Years Ago by pritaeas If you have already selected your connection and database, then in the toolbar there is a "new table" button. Lunerpages Hosting : Mysql connection problem using Navicat 8? 15 Years Ago by fuzkabir I use Lunerpages Hosting. I want to use the Navicat 8 for managing the mysql database in my Lunerpages …i can't access the mysql database of lunerpages using Navicat. please help! people claims that they have done it.… how? [url]http://thuannvn.blogspot.com/2009/02/using-navicat-ssh-tunneling-for-secure.html[/url] [url]http://translate.google… Re: PHP and Navicat Reports 13 Years Ago by pritaeas These files can only be used in combination with Navicat or their Report Viewer. I suggest you contact Navicat for an online solution. Free Navicat Equivilant? 17 Years Ago by samnav Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat? Re: Free Navicat Equivilant? 17 Years Ago by samnav I bought Navicat with $95 as an non-commercial user, it's cheap but powerful. PHP and Navicat Reports 13 Years Ago by garyrichard I have created a report using NAVICAT Report Tool Report has an extension RTM . How..Do i run this report on Online web server.. Re: navicat questions 14 Years Ago by teedoff I guess what I'm getting at is that when I eventually have someone doing data entry here at the office, I assume I would want her doing it locally first, then upload those new records to the remote server. So how then if we add database records locally, would I ensure that all records were handled correctly and all records would get put to the … Re: navicat questions 14 Years Ago by teedoff Yes I have tried to synchronize data from local to remote servers. It's always unsuccesful and says fields do not match. How far does "matching" entail? meaning matching field names or field names data types null allowances? everything? I have looked over both db and their tables and I dont really see any differences that stand out. … Re: navicat questions 14 Years Ago by teedoff Ok I found it...lol you DO have to have everything the same including data types. I had one data type as text in one table and varchar type in the local table. I just did a data synch and it works. Thanks! Re: navicat, MySQLand import wizard 14 Years Ago by teedoff here is the log file. Wow it's long! lol. I did notice something it says about duplicate primary keys. I'm very new to MySQL and databases in general, so not sure what all of this means. Thanks for the help! [2010-07-23 08:03:05] [Msg] Import start [2010-07-23 08:03:05] [Msg] Import type - MS Access database [2010-07-23 08:03:05] [Msg] Import … Re: navicat, MySQLand import wizard 14 Years Ago by pritaeas You are trying to insert records where the id (bulbID and brandID I guess) is already in the database. Since this is a primary key field, it is not allowed to be added again. It should be possible to not import this id field, but then you would probably get duplicate records in your database.