Carry Database From Wamp To Lamp
i created a database in WAMP ON WINDOWS ans now want to put it on my lamp server.but dont now how to do it.MySQL version is 5.0.x.
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 !
Connecting To A Database Using WAMP
I'm currently using WAMP to work on existing website and database material. I downloaded the required website, but it didn't run without the database online, so I dumped a copy of the database to my hard drive and imported into phpMyAdmin, but the website still doesn't connect to the database with the address 'localhost'. What would I use? Where do I connect to the database I imported in phpMyAdmin. Here's the code for connecting as well as the error message. // CODE <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_systemDB = "localhost"; $database_systemDB = "myDatabase"; $username_systemDB = "user"; $password_systemDB = "pass"; $systemDB = mysql_pconnect($hostname_systemDB, $username_systemDB, $password_systemDB) or trigger_error(mysql_error(),E_USER_ERROR); ?> // ERROR MESSAGE Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'eid'@'localhost' (using password: YES)
View Replies !
Carry Forward Column Values From Previous Rows
valuea, valueb, valuec, valued, e, f, g, .... null, null, null, valued, e, f, g .... null, null, null, valued, e, f, g .... valuea, valueb, valuec, valued, e, f, g, .... null, null, null, valued, e, f, g, .... etc. The null values in the first three fields should be replaced with the previous a, b, and c values. I'm loading the table using load data infile but I can't quite get my head around carrying these values forward. Can I do this with just an SQL statement, perhaps using ifnull(), or do I have to go to perl, or php, or similar?
View Replies !
When Should I Scale Out From One LAMP Machine?
I just have one server that runs Apache, MySQL, PHP. It handles requests fine and never had problems. When should I think about a small step into scaling? By maybe having an independent MySQL server? How many QPS (Querys Per second) (approx) on the MySQL DB will it be optimal for me to have MySQL on a seperate maybe more powerful machine? The current server has 1GB Ram and intel duo core processors..
View Replies !
Schema Privileges - LAMP
I have a Virtual Server from which I administer a few databases. I need to create complex queries including UNIONS. And to simplify my work, and to make objects available to my application I need the CREATE_VIEW privileges My "Root" tells me that MySQL 4.XX does not support the CREATE_VIEW privilege. My Global privileges do not have this value. How do I, or can I, add a CREATE_VIEW privilege to my list of available privileges?
View Replies !
ERROR 1045 :: LAMP On Ubuntu
I have installed LAMP on an ubuntu machine. Now when I use the command: mysql -u memyid -p it gives me this error: ERROR 1045 (28000): Access denied for user 'memyid'@'localhost' (using password: YES) I did input the password that I set when installing the lamp package. But I do not know why it is acting this way... could some one tell me where I'm going wrong?
View Replies !
Free LAMP-Image - Is It Legal?
I plan to make a vmware image, which contains a LAMP system, that means: Linux (in my case debian or a smaller one), apache, mysql and php5. My question: Is it legal? I want to provide this image for FREE!
View Replies !
Suddenly Mysql Won't Start (LAMP Server)
I use a LAMP-server running on Debian Etch as a virtual host on VMWare. I use mysql for a web gallery, but a couple a days ago it seems to stop working, so I tried to restart mysql and webserver, but mysql then fail to start. The syslog have the following info about it: Jul 22 13:11:12 webserver mysqld_safe[3587]: started Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [ERROR] Aborting Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [Note] /usr/sbin/mysqld: Shutdown complete Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld_safe[3592]: ended Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: error: 'Can't connect to local MySQL..
View Replies !
Phpmyadmin After WAMP
I cannot get into phpmyadmin after a WAMP reinstall - here's the error: #1045 - Access denied for user 'root'@'localhost' (using password: NO) What do I need to fiddle with to get this to work?
View Replies !
Configuration On WAMP
On WAMP, how do you configure MySQL? When I had it separately, I was able to set up my own password by doing the configuration, but with WAMP, I'm not sure how to do it, so I can't go into the MySQL console.
View Replies !
WAMP Issue Please Help!
I installed wamp onto my laptop (it's new) and everything went fine except that when I try and access the phpmyadmin from the control panel I get the error message 'php tried to connect to the mysql server, and the server rejected the connection. You should check the host, username password in config.inc.php then it tells me #1045 - access denied for user 'gokeeffe' '@' 'localhost' (using password YES) This is not the password that I set and I checked the config file and everthing seems to be inorder. Does anyone know what is wrong. Why is mysql + phpadmin so difficult to install?
View Replies !
Connection With WAMP
I have installed apache, php and MySQL using WAMP version 2. i can browser the local host, php just works fine. i can connect to the MySql server using Heidi SQL just fine. every thing is ok except i cant connect to the MySQL server using php code. just a blank page appear when i execute the below code. no errror message or anything display at all ....
View Replies !
MySQL Import On WAMP
I installed WAMP on XP to use a test server and can't figure out this silly windoze command line thing for MySQL. It seems my linux commands are Klingon to Windows. I try this.. mysql> username -p database < c:wampwwwfile.sql and I get a bunch of syntax errors. I tried dual slash and everything and it's not working. The file is 80MB so it has to be done at the command prompt. Is there anyone out there? Is there anyone listening? I've searched low and hi and there doesn't seem to be a page with how to do this. I've seen LOAD but that's just for a table.
View Replies !
Phpadmin Wamp Server
All I want to do is run a select query of all the records in my table where the arcade game name equals a specific name. I am using the sql creator to do this, SELECT * FROM `bb1_arcade` WHERE `games` = `asteriods`; But the stupid thing keeps erroring saying that asteriods is not a column. Of course its not a column! Its a value! What I want to do in the end is add a value to another field within this table based on the results of the select statement but its just never working.
View Replies !
WAMP Server Solution
I have been working as a LAMP Solution Developer where my technical specifications for the LAMP solutions are: Database backend server is MY SQL running in HP-UX (Hewlett Packard UniX) where I database composed of 9GB. My web server is running on WAMP’s version of Apache HTTP Web Server and my application server is running on WAMP’s PHP version and the platform running on the Web Server is Windows XP on the staging or testing environment. References I use is the wampserver.org The problem is when the client processes some reports from the Database by the PHP Web Page and generates reports through the Php, after 1 hour of validating it expires. Is there a script or an accelerator where I can use to increase the speed of the Php Page without having a page expire or the mysql table itself must be reduced so it can be easily accessed by a Php?
View Replies !
Reading Ibdata On WAMP
need to recover some data because of some faulty update statements. I have used mysqlbinlog to read the ibdata1 file. My command is mysqlbinlog.exe --result-file=idbata_logfile.txt --force-read ibdata1. When I open ibdata_logfile.txt there is only 7 lines if text at < 1K, but yet my ibdata file is 200M+. Is there something I am doing wrong? Are the update statements being written to that file? Is there a better place where I could retrieve the old information. BTW, this occurred between backups.
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
WAMP Upgrade - Now MYSql Not Working
I have been running WAMP on my local server for sometime but I needed to upgrade so I downloaded the latest version, stopped WAMP and installed the new version. The Php is working ok but the MySQL service won't start and I even tried starting it in the Services. When I browse to MyPhpAdmin I get this error: Error MySQL said: #2003 - The server is not responding
View Replies !
Error 1064 Console On WAMP Server
I am working through an SQL book which gives this example to create authorization for access to a database CREATE SCHEMA AUTHORIZATION JOE CREATE VIEW NEW_CARS AS SELECT * FROM CARS WHERE YEAR >1990; I get a 1064 error with using this code.I am using the MySQL console on WAMP SERVER v 2
View Replies !
Connecting Java With MYSQL In Wamp Server
import java.sql.*; public class Connect { public static void main (String[] args) { Connection conn = null; try { String userName = "root"; String password = ""; String url = "jdbc:mysql://localhost/test"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); System.out.println ("Database connection established"); } catch (Exception e) { System.err.println ("Cannot connect to database server"); e.printStackTrace(); } finally { if (conn != null) { try { conn.close (); System.out.println ("Database connection terminated"); } catch (Exception e) { /* ignore close errors */ } } } } } I have doubt that it is happening since MySQL is in C:wampMySQl.?? This is the output of StackTrace(); java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at Connect.main(Connect.java:14)
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
Database Transfer Between Oracle 8 Database And MySQL Database
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from ERStudio and then produce a SQL script that will insert the data into the MySQL engine. But I can't do this, because the customer want me to do a PL/SQL script that does this, even if he never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ?
View Replies !
How To Apply New Database Structure To An Existing Database, Without Overwriting Data?
I am writing a simple blog software application. We released a version of this software a while ago. It comes with a sql-tables.sql file, that you can just import into your mysql database and it will setup all the tables for you, for a fresh installation. We made the sql file by just doing an export I believe, without exporting the data that was in OUR database. Well, since then several people have downloaded and installed our software, and are using it. We are about to release a new version soon, however. Since it is all still under development, many things have changed in our database structure. We've added new tables, and modified or even removed fields from existing tables. So for the new release, we're going to include a new sql-tables.sql file obviously, so that for fresh installations they can still install it just like normal. However, the question is... how do you "upgrade" all the previous version's users's databases, without losing any of their data? Is there anyway to export just the structure of our current database... then somehow apply it so that it just goes through and changes another database to match the new structure? Or any ideas at all how to do this?
View Replies !
Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import properly?
View Replies !
Create Database Mysql Database In My System
I have installed MySQL 4.1.7-Standard in MacOS X (10.3.5). I have ONLY database test. According to the manual there should be TWO. test and mysql. I have re-run mysql_install_db several times with he same result. Can some mysql guru explain or point me to the right page to have this mysql database in my system?
View Replies !
Restoring Database In A Changed Database
I have a database name 'rtdb1' with a table 'review_table'. The 'review_table' has one column 'version' of varchar 20 type. I took the mysqldump of the rtdb1 database. Then I changed by table 'review_table' by adding one more column 'category' int type and called the database 'rtdb2'. But when I restore my dump of 'rtdb1' database to 'rtdb2' database, I don't see the 'category' column.
View Replies !
Database Error : No Database Selected
I am trying to install an application called weberp on my website. I have writen a script to test that the database name, user name, and password are all correct, and mysql is there and running okay. I entered a script into myphpadmin to establish the database. All the tables, and so forth, were created with no errors.
View Replies !
Extracting Data From Large SINGLE-table Database To MULT-table Relational Database
I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different articles. I want to create seperate tables for author, source, and category and populate the new tables by extracting data from the original single-table database by unique ID field. I figured out how to use INSERT and SELECT to pull data in new tables, but can't figure out how to pull only a single instance of a unique author, source, and category to create master reference tables for author/source/category.
View Replies !
USE Database Prompt :: How To Know About A Database
How do I know what database I am 'using'? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use databasename'. I am now using that database but have no visual cue. How do I include the username, database name, etc in the 'mysql>' prompt? Note, I can customize the command prompt on linux to include user, host, directory, etc.. so I always know who I am and where I am.
View Replies !
Convert Ver 4.0 Database To Ver 4.1 Database
I do not know if this is the correct forum to ask this in or not. We have changed hosts and the old hosting company was running MySQL version 4.0.27 standard and our new host is running MySQL version 4.1.22 Standard. We have a database from the old host that we need to convert to MySQL ver 4.1.22 so we can use it on the new host. We were running a older version of SugarCRM on the old host but we upgraded when we went to the new host and the new version of SugarCRM will not work with the copy of our old database file. It says that it needs MySQL version 4.1.2 or higher. Is there any way to convert the old data base.
View Replies !
Dropping Database Called "database"
I have finally managed to install and configure mysql on my pc for testing but need to import data from an Access Database. I first found out that I had to create a new user and grant priviledges to it - which means I could connect. My next stage was using the migration tool to import the data. This did not go so well... Firstly, many of the table names had spaces in them which means that they are effectively useless in mysql. So I thought I would start again, ensuring that the tables are first renamed in Access. I then went to show databases and, during the migration process, it has given the imported data the default name of "database". I now have a major problem deleting it as it thinks the name is an instruction! Anyone know how to get over this issue?
View Replies !
Move Table From A Database To Another Table In A Database
I am currently developing a project as I am only a web designer. I need to move a table from a database to another table in a database. I am using SQL Server 2005 Express. How is this done? I have been stuck for months trying to figure this out! I have even bought SQL Server Express 2005 for Dummies and cannot figure this out! I need someone to hold my hand and walk me through this literally! Or give me syntax code to do this.
View Replies !
Database Pw
i've searched quite a bit, but cant find any post relating to sql command for setting database passwords. anyone know how?
View Replies !
Same Database Name
Is there a way to prevent users from creating the same database name? for example our name schema goes like: mysql_1234, mysql_32143, mysql_.... But we found out that some one could create MYSQL_1234 while mysql_1234 already exists. I guess what we need to know is that if there is away for mysql to not allow same names even though its different case characters.
View Replies !
Database Name
Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to.
View Replies !
New Database
I am quite new to working with databases and am currently having problems connecting to my new MySQL database. I have been working with dreamweaver and have been using a db on my localhost which worked fine, however now I have set up a db with an online host and I am having problems connecting to it. I go in to dreamweavers MySQL connection control panel and fill in all the details that I have been given, user name and password, and from the top of my db website which says “MySQL 4.1.15-standard running on 217.174.253.162 as stopticket@server217-174-253-162.live-servers.net” so I use the 217.174.253.162 as the server, however when I try to connect I get an error message saying “2003 cant connect to MySQL server on “217.174.253.162” (10060)”. Has any one got any idea of something I could be doing wrong
View Replies !
Database Getting Too Big
i have a mysql database which i think is getting too big! I have about a thousand records which came from a form on my webpage and I am worried that i may get complications in future if i dont do something! My question for today is how do I archive my database so that I can go back to it whenever I need to find old records? Do i just use the mysql admin console to do a backup and then delete the table contents or what?
View Replies !
|
TRACKER
