Exporting Database From A Linux Server
the following query:
mysqldump web15db1 > sql.dump
where web15db1 is the name of my database.
And i get a syntax error:
Quote:
View Complete Forum Thread with Replies
Related Forum Messages:
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
Exporting From PhpMyAdmin On Server To MAMP On Local Machine
I thought that transferring the database from the server to my hard drive and working with it using MAMP would be fairly simple, but I am lost on the options and get: Error SQL query: -- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 22, 2008 at 11:02 PM -- Server version: 5.0.27 -- PHP Version: 5.2.1 -- -- Database: `trumpet` -- -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE `articles` ( ... etc. ... ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =15; MySQL said: #1046 - No database selected Could someone give me some guidance on how to get the database to my hard drive so I can develop locally rather than via the internet?
View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server. If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields? In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names? Or do they matter?
View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it. When i try to connect the ODBC allways returns the following error: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001) I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc... The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.
View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net. Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine So please tell me process 1 have to simply upload my mySql database in Public Html folder or else where i m using cPanel file manager to upload files
View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
View Replies !
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: [root@psiche root]# mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the mysql_install_db it reports some errors: "asked for 196608 thread stack, but got 126976" and "to start mysql at boot time you have to copy support-files/mysql.server to the right place for your system".
View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located. I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side? I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit. But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts? I'd like it to be command line, so it can be run from another application which would then run this from a shell.
View Replies !
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql. The file contains around 30000 data but after i've typed: mysql> source /xx/file_name.sql; Table of the sql file is created but contains no data. But it poped an error notice without any message: ERROR: <----like this the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?
View Replies !
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting. I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.
View Replies !
Problem Exporting MySql Database
I'm trying to move a site to a new host - the problem is my new host is using a different version of mysql. (a newer version) when I export the database and try and import it to the new one they seem incompatible and I get this error MySQL said: Documentation #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'contentId` int(10) unsigned NOT NULL auto_increment, `section Any ideas on how I can import the database?
View Replies !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux ) WHM 11.11.0 cPanel 11.16.0-S18450 REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0 after update apache then all websites on server can not connect mysql from WHM > Tweak Settings > Mysql > 5.0 and used old style (4.0) passwords with MySQL® 4.1+ also command /scripts/mysqlup but no way still same error can not connect to Mysql
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and RH9 Linux. the intranet was first set up and running in win98. I have a mysql database in the win98 . The win98 partition is mounted in Linux and is accessible. I am duplicating the intranet in Linux. the HTML pages are accessing from the win98 partition. Is there a way to use the database as such by the intranet in the Linux.
View Replies !
Sharing Database Tables Between Windows & Linux
I'm new to MySQL (using v4.1) and have a dual boot machine with Windows and Debian Linux (Etch). My goal is to share a table named "wordpress" between Linux and Windows by storing it on a FAT32 mount (I realise this limits me to 4GB in total). From what I can see at the moment, the "wordpress" tables live under /var/lib/mysql/wordpress. Numerous searches have revealed how to backup data, but I haven't seen any clues on how to permanently reloate a database to another location.
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
View Replies !
Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as back-end Database on Linux Operating system. I need to backp all these Inventory database into CD/Tape/Floppy, which is the right directory (MySQL database) to backup (incase if the current MySQL server crashes, then I should be able keep copy of my inventory),
View Replies !
Exporting A Database While It's "being Used"?
I have a relatively active forum that has recently become even busier than before. I used to export the database once or twice a week without closing the forum first, but recently it takes a lot longer to export the database, so I was just wondering if there would be any type of error/problem if I'm exporting the database while someone is making a post or something like that?
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Database Server
I have installed MySQL on WinXP Pro When attempting to access various commands from the command prompt (eg help, set password etc) I get the following error. ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) When trying to access the MySQL server via a local web page I am also unable to connect to the database. I have successfully installed Apache 2.0.35-win32-x8 and PHP. Appreciate any suggestions for what may be the problem here. Also how do I import databases and their records from a previous install on another computer?
View Replies !
Replicate Database->Server
I'm trying to replicate a database to a server. from the server I try : mysqldump -h remote_host --opt --compress eslsl -u dbmaster -p mysql eslsl Enter password: mysqldump: Got error: 2003: Can't connect to MySQL server on 'remote_host' (60) when trying to connect I'm sure from the remote host name / ip but still can't connect from another machine. Does someone see what's going on. Is that a permission trouble ?
View Replies !
Configuring Database Server
tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD. Is there a toaster than can bring me up to speed.
View Replies !
Database Server Connection
I am trying to using mysql as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish the connection between database server and application, should I keep this connection open while application is running, or only open it when there is a requet to qury records from database?
View Replies !
Database From Localhost To Server
I have created a database using mysql on my localhost. I entered all the relevant data and all that. The problem I have now, is to create the database on the server, but I dont want to re-enter all the data. Is there a way I can copy my databse to the server?
View Replies !
Importing Database :: Server Has Gone Away
i'm trying to import a sql file into an empty db (no tables yet) mysql -u root database < c:database.sql i get this error: ERROR 2006 at line 380: MySQL server has gone away the sql file is more than 15 megas of size (i don't know if this is the problem) and has no errors because it was generated by phpmyadmin 2.6 what can i do to import my db?
View Replies !
Database To Mysql Server
I have a rather large backup of a database (252MB) that I need to install on new site, I usually run phpmyadmin, but it can't handle a file of that size. Is there another method I can use to install a file this large back into the mysql database?
View Replies !
Transfer Of Database On Net Server
I have been using my database on my home testing server for over a year and now I want to change to a server on the net. I've already bought my hosting plan and now I need to upload my database to the server. I've tried to use the backup utility in cpanel and even tried to use a text file of sql querys in phpmyadmin. I can't get any of this to work. I also haven't found any good tutorials on the net on this subject. I've also searched this forum and still can't find a step by step walkthrough. I used navicat to produce my sql dump( database.sql) but now how can I upload that to the server. When I use the sql text file in phpmyadmin I get this error #1044 - Access denied for user: 'name@localhost' to database 'database'
View Replies !
Reporting Database On Different Server
I want to have a reporting database in a different database that exists on a different server that is more/less(?) normalised for faster reporting. Is there any easy way to move data between different databases that are on different servers???
View Replies !
Can't Start Database Server
I am trying to start the MySQL server after having installed 5.0.22 for the first time. On the first go I tried running as root and it failed. I then gave mysqlf access to /var/lib/mysql and ran it as me with the following result: 060818 21:41:23 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060818 21:41:23 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 060818 21:41:23 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 060818 21:41:23 InnoDB: Started; log sequence number 0 43655 060818 21:41:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist It looks like I need to recreate the database but I do not know how to do that. Can someone help me with this?
View Replies !
Chat Database Server
i m currently developing a web application using asp on windows 2000 and mysql. this application has a 1 to 1 live chat function for all members. however, i feel that the database retrieval for the chat is very slow. Currently, the web server and database server are residing in one processor. should i separate the web server and database server? or how can i improve the performance?
View Replies !
Uploading Database To Server
I've got MySQL installed on my PC, and created a database called "CMF" for a client's website. Now I'm setting up MySQL access with my new hosting service, and I'm trying to upload the CMF DB to the server so the client can view my progress. To do this, I am trying to use mysqldump.exe to export the DB. In Windows command line, I type: mysqldump.exe -e -n -uroot -pyeha -hlocalhost cmf > c: empcmf-mysqldump.sql and I get the error: mysqldump.exe: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: YES) when trying to connect Am I anywhere near the right track on this? Can I (or should I) create/upload databases or tables using MySQL Query Browser?
View Replies !
|
TRACKER
