Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, I can even shut down MySQL if needs be. 4) The database is mostly MYISAM but with a few InnoDBs and a couple Memory (VBulletin) 5) Both servers are Linux based and I have root access on both. I've done the transfer using a mysql dump, but the import took …

Member Avatar
Member Avatar
+0 forum 14

![wqe](/attachments/small/3/wqe.jpg "align-left") Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC

Member Avatar
Member Avatar
+0 forum 5

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 it actually stops processing records at 850,825 records. The log shows no errors whatsoever but I know there are many more records. Why is it not importing all records? Here's the log: [2011-09-21 09:37:24] [Msg] Import start [2011-09-21 09:37:24] [Msg] Import type - Text file [2011-09-21 09:37:24] [Msg] Import from - Y:\DistroPartner\EmailCampaign_ClassicActive.csv [2011-09-21 09:37:24] [Msg] Create table [Classic_Active] [2011-09-21 09:37:24] [Msg] Import table [Classic_Active] [2011-09-21 09:42:41] [Msg] Processed:850825, Added:850825, Updated:0, Deleted:0, …

Member Avatar
Member Avatar
+0 forum 4

I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to save to FlashDrive is I dont have Access on the pc at work, and I dont have Navicat on my laptop. Complicated I know. Anyway, the first time I imported, I selected "Copy: Delete all records from destination and repopulate the source..Woked fine. Next time I tried to add more …

Member Avatar
Member Avatar
+0 forum 11

The End.