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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 !
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 !
Schema Help
I'm building a database were I will have 1,000's of records information. This will include a unquie id for each row that contains name, street, city, phone (area code and 6 digits), URL, stock ticker if available, description, contact, date of contact, etc. (about 17 items in all) To make for faster look ups I intend to create a table where I can look for areacode and unique id. This way I can find all businesses in an area quickly. I'm using MySQL.
View Replies !
Db Schema
Have used Oracle and SQL Server for many years but have never worked with MySql yet. How can I get all the tables and their definitions? I'm assuming there are system tables that would store this information and that would be helpful. Is there a way, through a gui, to get this info? Is this gui, if exists, only for certain platforms? I need to start administering the schema and the gui option would be great for a start.
View Replies !
How To Log A Particular Schema
On the MySQL server which is hosting the schema that my application uses, there are other schemas too. As a result the MySQL log has information from the other schemas. Is there a way to filter out messages from my schema alone?
View Replies !
View Schema
is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic.
View Replies !
Data But No Schema
I have my data in a csv file which I will import into mysql. I need to develop the schema. I just want to use the column names in my csv file. Is there a tool that I could use which would recommend a schema? I have about 40 columns so to go and figure out each column would take alot of time.
View Replies !
Schema Vs Database
It seems that schema and database are interchangeable terms with the same meaning in MySQL, is that right? Is this how it is in other RDBMSs, or is MySQL different in this regard? Looking up briefly on other RDBMSs, it seems that they use database to refer to the database (good description, huh? ) and schema to refer to the "owner" of that database? I don't really know what the difference is, and how to define on versus the other. Can somebody explain the difference (better than my "a database is a database"), and why other RDBMSs see a need to do it this way (i.e. what's the benefit of implementing a whole other concept known as schema)? Does MySQL have plans to change things in the future on this issue? Or have I totally misunderstood the concepts of database vs schema, and how MySQL defines it?
View Replies !
Schema Evolution
I have just started using mySQL for some database needs and would like to learn how to modify a database to bring it in line with new schema definitions that I have. My changes are deletion of columns, marking of a column unique, merging of colums. There is also significant intercolumn relationship and I guess I would need to update that too.
View Replies !
Loading Schema
I've been importing a database from a MSSQL server - not massive, 146 tables, about innodb_buffer_size 20GB total data and everything is fine with running queries - performance is good considering it's on a dev box at the moment. Problem I have though is when you are using phpmyadmin or the mysql administrator it takes an age to load table data (in mysql admin it says 'Fetching schema table status'). These are innodb tables (I'm concerned myisam won't cope with us - lots of small updates and big slow queries) and if I convert the tables to myisam the problem goes away - loads fast as you like. Is this a problem inherent to innodb or is there a configuration to get around it? I'm running with default my.ini atm with the exception of innodb_buffer_pool_size=500M.
View Replies !
Compare Schema
I have two MySQL database. How can I compare the schema. I wan't to see if there are any differences in them. Is there a tool for this?
View Replies !
Schema Suggestions
I've managed to create some fairly simple databases up to now, but need some suggestions on the best schema for this. I want to store some product details (inkjet cartridges) with the following data: Printer Manufacturer Printer Model Cartridge Ref No Cartridge Description Compatible Price OEM Price Reman Price I need some ideas for how best to go about doing this - what's confusing me is the how to cater for the fact that the Cartridge Ref No can apply to many Printer Models.
View Replies !
DB Schema Extraction
Is there a quick/easy way to extract the schema for an entire database so that I can quickly re-create the database on another server (without all the data)? I can use the GUI Query tool (or the Administrator -- not sure which), and select each table, one by one, and extract the SQL syntax to create that table, then append them all together in a single SQL file.. but that's tedious.
View Replies !
Add Table From Different Schema
i have this 2 imported database from microsoft access namely payrolldata and ytd_table. is it possible for the tables under ytd_table be added to payrolldata schema including the rows of these tables?
View Replies !
Export Schema Via SQL
I am needing to export the schema for a DB. Unfortunately I don't have command line access or access to a tool like phpmyadmin.. I only have access to it via PHP (Long story). Is it possible to export the schema for a DB via php? I've found the CREATE table LIKE table command.. But can that be used to create a table on server y based on a table on server x?
View Replies !
Schema Engine
Does any one know how to retrieve the schema engine(InnoDB, MyISAM) from the MySQL Server without querying the INFROMATION_SCHEMA .
View Replies !
Relational Schema
How does one view the relational schema of an existing mysql database.... I also notice that there is a database called information_schema when I log-on to mysql comand line... using ubuntu....
View Replies !
Schema Support In My SQL
My second question is if MySQL supports schema why does my below code always returns me null instead of valid value. String url = "jdbc:mysql://localhost:3306/builder2"; Class.forName ("com.mysql.jdbc.Driver").newInstance(); Connection conn = DriverManager.getConnection (url, "root", "n0tall0wed"); metadata = conn.getMetaData(); String[] names = {"TABLE"}; ResultSet tables = metadata.getTables(null,"%", "%", names); while (tables.next()) { String tableSchema = tables.getString("TABLE_SCHEM"); System.out.println(tableSchema); } This code successfully works in other RDBMS databases.
View Replies !
Duplicate A Schema
In short: I want to make a carbon copy of a website that I want to use as the mysqllate for other websites. Server: winxp, mysql 5.0, php, apache, and Joomla content management system. All on localhost here. I can manage the apache and joomla copy, but want to know an easy way (in windows) to duplicate the schema in a similarly easy way. schema "site 1" I want to dupe to "mysqllate" then copy "mysqllate" to "site 2", "site 3", etc. In the same sense as a carpenter's jig.
View Replies !
Updating Db Schema
I was thinking something like mkdir dump mysqldump -p --tab=dump dbname mysql> drop database dbname; mysqladmin create dbname cat newschemafile.sql | mysql -p dbname mysqlimport dbname dump/*.txt But when I do it this way I seem to be left with the same schema I started out with.
View Replies !
Schema Does Not Exist? Yes, It Does!
I usually administer my database locally, but I've been experimenting with some .NET applications and decided I should learn to administer remotely so I'm trying to do so with the MySQL GUI tools... (Query Browser and Administrator) After some initial connection issues that turned out to be a firewall I successfully added a user and I'm atmysqlting to connect remotely now. When I enter my server's information (Host, port, user, password, and default schema) and click OK, I get a dialog box titled "Connection Dialog - Default Schema Does Not Exist" that reads "The schema 'opcdata' does not exist. Do you want to create the schema now?" (Yes, No) Clicking no takes me back to the connection dialog. Clicking yes results in a 1044 error.
View Replies !
Schema Change
I'm having a strange problem when trying to change the type of a field in one of my tables. I need to change the email column from varchar(40) to varchar(60). I do an ALTER TABLE tablename CHANGE email email VARCHAR(60); to make the change. The problem I'm having is that (this is a large table and I'd expect it to run for a few hours) the change runs for over a day and never completes and it doesn't crash the server but it kills network connections to the box. At least I think its a result of the jump - its the only thing of consequence running on the server.
View Replies !
Synchronizing Schema Changes
Is there a relatively easy way to synchronize changes to table structures without loosing data? What has happened is that my friend was desperate to use the project before I was even done determining what was needed. Even now he is requesting new features and fields but he has data he needs in his online version. What would the best method be to roll changes out from my development environment onto his live version without loosing data?
View Replies !
Mysql Schema
I was wondering if someone would be kinda enough to have a browse over my mysql database schema that I've drawn up. This is the 2nd one I've done up for this project ... a friend suggested some changes. So I've made them and this is what I've got so far. Code:
View Replies !
Database Schema Ideas
My company sells widgets. In our 'shopping cart' that we're building, we want to list out the price for each widget. The problem is that the price varies depends upon which widget package (out of 10) as user selects, as well as which website (out of 8) they visit. So, 80 different possible prices per widget (and there are lots of different kinds of widgets). Does anyone have any recommendations on how to build a database that will help prevent a separate record for each of the 80 different possible prices for each widget?
View Replies !
Copying A Table From One Schema To Another
Is it possible to copy a table from one schema to another schema by just copying the frm file to the directory for the new schema? What is the best way to create a new database with all the tables in it automatically? I was hoping to have the tables (the frm files) included in a subdirectory and when required, just create a new schema then copy all the frm files into it.
View Replies !
Schema And Catalog Under MySQL 3.23.55
I try to investigate some of the basics behind schemas and cataloges, Which is part of SQL2 Language this is the error message I get: C:mysqlin>mysql -u administrator -h localhost -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 246 to server version: 3.23.55-nt Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> create schema company_00 authorization administrator; ERROR 1064: You have an error in your SQL syntax near 'schema company_00 author ization administrator' at line 1 mysql> use company; Database changed mysql> create schema company_00 authorization administrator; ERROR 1064: You have an error in your SQL syntax near 'schema company_00 author ization administrator' at line 1 mysql> create schema company_00 authorization administrator; === it seems to me that the sql statements schema and catalog is not working in my version of mysql. What can be done in order to remedy this ?
View Replies !
Database Schema Design
Each article/faq item can be associated with some topic (and both articles and faq items have nothing to do with each other) Right now i have 2 separate topics tables for articles and for faq items but these tables have exactly the same schema(same columns) The alternative is to use only one topics table and have additional column used to figure out if it is article's topic or other's.
View Replies !
Create A Visual Db Schema
I have a mysql db and want to create a nice-looking (or just simple) visual schema like these: http://images.google.com/images?q=database+schema How can I go about doing this?
View Replies !
Database Setup / Schema
I am new to the forums but have used the site for reference many times in the past. I am currently taking a directed project course at my university and my project is to develop a PHP/MySQL based statistical tracking program for a basketball team or teams. I have worked with both PHP and MySQL a little before and am hoping to become more proficient in both as I tackle this project. I'm trying to setup the database schema with DBDesigner. Here is a link to the BMP file and a DOC file with some needed fields and a sample txt file which the online app is supposed to handle: URL URL I have not yet setup the relations and need to make sure that my database is efficient and normalized. I also think that I may be missing a few needed tables and/or fields
View Replies !
Create Any Table With Name Schema
I created a database, then I try to create a table with name schema, but mysql don't allow me to do that, it says: "Database ERROR: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 'schema ( vseq int(10) unsigned NOT NULL default '0', ' at line 1" why?if I change schema to schema2 or any other name the table will be created and no problem oocure.what is wrong in this command?
View Replies !
Copy MySQL Schema
i have a friend doing a project with me and we want to have same SQLschema name "projectez". He had created one i sent me the schema. i put it under the data folder but when opening the schema using a query browser it says that the table cannot fetch columns. why is this so? how to solve the problem?
View Replies !
Creating Schema DIFFs
I was wondering if anyone knows of a tool that can publish valid DIFFs for schema exports, we're working on rather large project and currently it takes a substantial amount of time to rebuild the whole db, yet the changes between each build are minimal when it comes to the db schema and it's data... I was hoping for something that will just isolate the difference and produce a valid script to bring up the schema to the last version.
View Replies !
Difference Between User & Schema
In oracle, a schema and a user are the same, meaning a user can create one schema. In MYSQL it seems like they are different. Any one care to comment about the difference/realtionship between an USER and a SCHEMAin MySQL.
View Replies !
How To Create Schema Dump
I need some help about how to dump only database schema, not the data. Our database already has data.But i want to create a database dump only for schema with out data. I think mysqldump dumps schema along with data. Are there any options i can specify which will let me to dump schema without data.
View Replies !
Change Schema Through Mysql...
I have a file .Sql and I want is to change the schema: -- -- Create Schema MySQL -- Create database IF NOT EXISTS mysql; USE MySQL; mysql through, it can be? i need this... -- -- Create Schema other_name -- Create database IF NOT EXISTS other_name; USE other_name;
View Replies !
Import Schema Database
I am installing ECM Drupal and I need to import schema, tables, etc I downloaded file "database.4.0.mysql" How to import it to my MySql????????
View Replies !
|
TRACKER
