Transforming Sql Server Data Base To Mysql One ..
I have an sql server Database Backup , I got it from My client who wants to rebuild his site with php-mysql .
What i want to do is to transform the sql server backup to MYsql one without losing any data ..
I want to do this without Loading the sql server on my PC ...
i tried many tools but it requires a pre-installed version of sql server to connect to ..
I have the sql server bckup file with the name website.bak
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How To Change Read/write Permission On Mysql Data Base.
I had a total crash and the server guy gave me all my data in a hand basket.. just kidding.. Actually I was given the data all zipped up and the mysql data bases were separate and they were the direct downloads as follows: wp_comments.MYD wp_comments.MYI wp_comments.frm all data was in this format. I used SSH and uploaded it to the proper directory on the server and all is well at least as far as visitors seeing all the data.. but when I log into the site I get the following... WordPress database error: [Table 'wp_options' is read only] UPDATE wp_options SET option_value = 'O:9:"magpierss":18:{s:6:"parser";i:0;s:12:"current_item";a:0:{}s:5:"it ems";a:10:{i:0;a:12:{s:5:"title";s:13:"WordPress 2.2";s:4:"link";s:54:"http://wordpress.org/development/2007/05/wordpress-22/ I used SSH and tried to change the concerned files to writable and it works fine but the same error is generated. I can go direct to the data base using myAdmin and cannot edit (write) to any table. It says the data base is read only. On the same mysql area, I have another data base that was done via the normal way and I can write to it just fine. I can find nothing to change to make the site writeable. Any help here would be greatly appreciated.. SSH to the server and changing the files to writable has no effiect..
Recreate Data-base?
if i build a temprorary DB on my server for a clients site while i create it. is there someway i can make the DB give me a creation code that i can give to the client to re-create my entire temporary DB?
Restore To New Data Base
I am using a heavily modded PHPBB forum and want to convert all my posts, users, etc, into a new PHPBB forum using some other mods. I am using MySQL 3.23.58 . I ran the conversion steps as the creator fo the modded forum stated but at the point where I run the install.php page I get an error that says "installation aborted as table xxxxxx already exists." Is there a way around this like perhaps makign the new tables over write the old tables? I need to keep the tables as they are or I will lose the posts and such.
One Big Data Base Or Many Smaller Ones
I am creating an on-line course and would like to know if it will make a difference in the way I set up my database(s). Option 1 : Create one large Database for the course Here I would prefix the tables with their functions, ie. reg_ quizzes_ forum_ etc. Option 2 : Create a smaller Database for each function Here I would create a registration database, a quizzes database a forum database etc. I do not have my own server, so I would have to get my ISP to create each database, which might be a hassle for them.
Data Base Transfer
Im trying to learn if it is possible to transfer data from one mysql to another with a diferent structure ie different table names etc am I beating my head against a brick wall? .... its thick enuf.
LINKs For A Data Base
I am trying to create a database that have email addresses. I would lie it so that when some one clicks on the email address, it would open up the email ( mailto:xxxx.xxxxx.com) , yet I want it to display as xxxx.xxxxx.com (as a hyperlink) The above answer might answer the next quest, but if not please advise on it as well. I would like to create a link to a different page in a table (pictures of people), again, this should be a hyperlink.
Transfer A Data Base To My Site
i've create a data base with phpmyadmin in my computer and now I want to put it in my site...it's possible to do it? And how?
Access Intranet Data Base
I have a db in my intranet, and I need to access the information from my web site which is hosted somewhere else (internet). Whats the best way to do this? Should I use a public IP for my intranet server? (then theres no point on hosting my web site some where else right?Could I syncronize both MySQL data bases?
Transaction Timeout For Data-base Mutex
I'de like to use transaction locking mechanism as a mutex. I've already succeeded making this work on pgsql. The algo is simple: I open a connection, set lock timeout to whatever i want, start the transaction and try to update a dummy row or create a dummy table (P/semTake of mutex), check if I got the mutex token (affected rows > 0 on update, no error on create table) (if not exit), execute my critical job and finally close the data-base connection causing a roll-back on update or create table (V/semGive of mutex). with MySQL, I haven't found anything to modify the lock timeout. Does someone know?
Moving Data Base From / Var To Home Directory
I'm successfully running MySql under Debian with the data files in /var/lib/mysql. I would like to move the data base files to my home directory and have mysql use them from there. How do I do it? Can I just copy them to my home directory and start mysql with a parameter which point to the new locaion? Can I do that with mysql starting at boot time? I just looked at /etc/init.d/mysql and see that it appears to starts mysql by calling /usr/bin/mysql_safe but there is no such file. As an alternative to putting it in my home directory, I would be happy putting the files in /usr/local. Can I do that without rebuilding mysql? The reason I want to do this is that I want to install a new version of Knoppix and that will format and clean out the / partition and I don't want to loose the data I have in /var/lib/mysql. Could I just save /var/lib/mysql and restore it after installing the new version of the system?
/var/lib/mysql/base-bin Files?
I run a hsoting company and we have a dedicated server. Our server details are at below: OS: CentOs 4.5 Recently I have discovered server disk usage is getting bigger with no reason. I have googled the issue and find out exim temp files were getting very big. I have deleted them. Also I have figured out /var/lib/mysql/ directory is another large directory. In the directory there are base-bin files. Can you tell what these base-bin files for. I do not think they are neccessary for server but I did not want to delete them without knowing what they really are.
Anyone Using OpenOffice BASE As MySQL Frontend?
I recently saw OpenOffice's Base: "BASE enables you to manipulate database data seamlessly within OpenOffice.org. Create and modify tables, forms, queries, and reports, either using your own database or BASE’s own built-in HSQL database engine. BASE offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users ... For more advanced requirements, BASE supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL)" I' am interested to hear anyone's experience with using this as a tool, development tool, or front-end builing tool for MySQL apps.
Sharing Data Between MySQL And SQL Server
I have a client who is using SQL Server for a database over 3 geographically diverse locations. Each location has a copy of the database which is updated constantly across their WAN. I have a single location MySQL database We have a need to share one table between the two structures. Is there any way that MySQL and SQLServer can share and mutually update a table between the two. ( I can't just leave the data on their server because if they take their db down, for whatever reason, the missing table will cause serious problems and effectivly shut down work on our operations. )
ERR: Data (not Date) From SQL Server To MySQL
How do I get data from my tables in SQL Server into my tables in mySQL. I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center).
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
Retrieving Data From Non-MySQL Server Via ODBC
I'm investigating using MySQL instead of the dreaded Access to retrieve logged information from a process control system. Is there a way to use ODBC to get rows INTO MySQL? All I can find in the manual is how to set up MySQL as an ODBC server for other applications. The control system is configured as an ODBC server, and Access will connect to it, but hangs and dies when I try to retrieve data.
Copy Data From Database On Server A To One On Server B
In an older version of MySQL that defaulted to MyISAM table types I could simply copy the contents of the MySQL/Data/DbName folder to a similar folder on another server and the MySQL on that server would, following a reboot, see the entire database. Using the 4.1.12 version of MySQL the default is InnoDB tables ( and I do want to move to transaction save tables anyway ) - which do not respond to the same treatment. How can I copy and entire database from one server to another ( this new server is at a different site, connected over the VPN ) Both servers are running MySQL 4.1.12 on a Windoz operating system.
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us. What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job. Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days. So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery. How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
First Base
I'm trying to follow some simple instructions but I just can't seem to get anywhere. I'm running it through XP, I've installed it and can get into winmysqladmin no problems at all. It didn't ask me for a password or anything when I started which some of the books suggested. I set up a user s_roper with a password and went into the command prompt to create a database. I typed in the username and password and it was all correct but it just keeps saying access denied. I set up the root user and set a password for that but it keeps saying the same :access denied for user: 'root@localhost' <using password: Yes> So I decided perhaps I'd done something wrong so I removed it and started again but it seems even when I remove it it still holds the passwords and users.I'm completely stuck.
Views And Altering Base Tables
I want a view that contains all the colums of the base table but only the rows where the index "owner" is a certain value. Easy enough CREATE VIEW bt_42 AS SELECT * FROM bt WHERE owner=42 This seems to me to be easier, quicker, and more maintainable than enumerating each column and it seems to work. Now the question is if I happen to add another column to bt will that automatically be reflected in all views that were made by SELECT * ? Seems like it should, since updates to other columns of bt would be reflected in bt_42
Delete From Multiple Tables Base On 2 Values..
.. the title pretty much says it all. My experimenting led to two of my tables being dropped so, i'm looking for some help! i need to delete from 3 tables but only the row in each table that has the user column and pic column equal to the values i pass it. I hope my problem description is clear enough.. let me know if it's not!
Data From SQL Server
How do I get data from my tables in SQL Server into my tables in mySQL I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)
Data From 1 Server To Another
i have 2 databases -- one a replica of the other. but they're on different servers. how's that for a twist?what i want to do is copy data from one table to another. how do i go about doing that when they're on different servers?
Data From Other Server
ther are two PC: PC1 and PC2 both have Mysql DB i want to select data from PC2 DB and insert to PC1 DB. how to write the command and any syntax??
Copying Data To Server?
i have some database elsewhere than the server, and i'd like to use this db on the mysql system, but can i just copy some mysql databases to the server's data folder? (do i have to "create database..."?)
Retrieving Data From Server
I was able to query the local Access database for all kinds of information but now because I am uploading the information directly to the website I do not have this information available on my local machine. Is there a way that I could download the data file as and when required from my server and insert it into Access or something similar that would allow me to run queries? I thought I was doing well up until this stage but my decision to make the process more efficient seems to have caused more problems.
Extracting Data From SQL Server *.DB File
I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand. I've tried using Crystal Reports and SQLyog but they don't seem to work, either.
Data Recovery From Dead Server?
I have had a remote fedora core 5 server fail on me and need to recover the database data however I can only ssh into it and it has changed to a read only file system. This resulted in mysql being unable to start for some reason so I was wondering if anyone knew how I can rescue the raw data from the server and recover it in my local working server. Where would the data from the mysql database's be stored and after I have copied it out, what would be the correct method of recovering it into a working database again.
Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors. The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2. I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?
Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server? I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.
Creating A Data Dump & Uploading To Remote Server
I've just taken an intro class on PHP and MySQL. I've got the technolgies running on my local machine. I can't seem to get a detailed, easy to understand, step by step guidance on how to transfer what I've got locally to my remote web host who is running MySQL and phpMyadmin. I'm running MySQL Server 4.1. Need to know how to copy my SQL tables and database to a sql file and then upload.
How To Backup Database Data Without Direct Server Access
I need to backup a MySQL database (MySQL 4.0). But it is on a shared-hosting web server and so I don't have direct server access. I also have no phpMyAdmin installed. How can I backup the database? I think it is possible with PHP (version 5.0.2 is installed on the web server) to create a file with SQL commands which restore the data, but what is the easiest way to do it?
Delete Rows From Table A, Which Dont Exist In Table B (base On Column X)
I have 2 tables identically structured. A & B Table A, has column: Product (product code) as primary key Table B doesn't. Apart from that they have the exact same fields. There's also a column: supplier I want to Delete * from table A, where does not exist in B (based on column: Product) & where supplier = apples So to elaborate. Table A is my main table, but it now contains outdated products from supplier apple. Table B has the latest list of products from supplier apple. So I want to remove old products from A that supplier apple no longer makes. mysql version 4.0.27
SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this: Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow. The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.
Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems. As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing. Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger. The mysql error log doesn't show anything weird either. To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.
Does Mysql Store Max Size For Data Type Each Time, Or Only What Is Needed For Specific Data?
If I use MEDIUMTEXT, which (if I understand correctly) has a max size of 65k, does mysql use the entire size each time data is written to that column? I have a text field on my site that users fill in, but more often that not, they don't. However, when they do, it can be 1000 bytes or more. Am I wasting space using MEDIUMTEXT or does mysql only set aside 1000 bytes for that column if the data is only 1000 bytes?
What MYSQL Data Type Can Hold Multiline Text Data?
say a file: name#1 (start) line2 line3 ... line14 (end) name#2 .... name299 .... <eof> It's really too messy to split into fields, file process and put it in tabular format. Every 14 lines there's a new "record" - I use the term record very loosely because by record I mean one data item eg. The new "records are separated by name# - so when I see a new name# I know it's a new "record". So in mysql I might have one primary key and just one other filed per a record that would be multiline text. What I an specifically asking is: What MYSQL data type can hold multiline text data?
Help CHECKING FORM DATA AGAINST MYSQL TABLE DATA
PHP // See if relevant fields have been set. $submitted = IsSet($_REQUEST['Submit']) ? TRUE : FALSE; $user = IsSet($_REQUEST['username']) ? cleanValue($_REQUEST['username']) : '' $pswd = IsSet($_REQUEST['password']) ? cleanValue($_REQUEST['password']) : '' if($submitted) { // Form submitted yet? if (empty($user) || empty($pswd)) { // Are Form fields empty? // Display error message when fields are not filled in. $message = 'Make sure you enter both a username and password.' } else { /* THIS IS MY HUMBLE EFFORT BELOW AND IT DONT WORK HELP */ //CONVERT PASSWORD FROM FORM INTO MD5 $pswd = md5($pswd); //CONNECT TO DATABASE $connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd") or die ("Couldn't connect to server."); $db = mysql_select_db("$database_name", $connection) or die("Couldn't select database."); //SELCT TABLE AND DATA $sql = @mysql_query("SELECT * FROM users WHERE username='$user' AND password='$pswd' AND activated=Ƈ' "); if (!$sql) { exit('<br /><br /><h3>Error retrieving Art members from database!<br />'. 'Error: ' . mysql_error() . '</h3><br /><hr /><br />'); } //MAKE VARIABLES FOR CHECKING FORM DATA AGAINST IS THIS RIGHT!! while ($login_check = mysql_fetch_array($sql)) { $user = htmlspecialchars($login_check['username']); $pswd = $login_check['password']; //NOT SURE FROM HERE // ORIGINAL SCRIPT BELOW // Authenticate username and password (i.e. match against a database). // Start a session only after username and password have been verified. THIS IS THE EXAMPLE LOGIN CHECK THAT CAME WITH THE CLASS if ((!strcmp($user, 'empl')) && // Does username match 'empl'? (!strcmp($pswd,'demo'))) { // Does password match 'demo'? $sess_param['new_sid'] = TRUE; // Create new session ID to be safe. $sess_param['security_level'] = 100; // Security level for Employees area $sess_param['gc_maxlifetime'] = 300; // Inactivity timeout of 300 seconds (5 minutes) $sess = new DB_eSession(&$sess_param); // session_start() done. $sess->setSessVar('authenticated', TRUE); // Set that authentication occurred. // Save the username for displaying and encrypt $sess->setSessVar('username', $user, ENCRYPT_VALUE, EXTRA_FIELD); $URI = $sess->setSessURI('employees.php'); // Optional - pass session ID in URI. Not as safe. header("Location: $URI"); // Go to members area. exit; } REGARDS Bill007
|
TRACKER
