WeaponX
Jan 19 2006, 05:49 AM
| | I wanted to use my live forum database (in another webhost) on Astahost for testing purposes. But I guess the free accounts we have do not support that restore backup option...tried it and got a message saying that.
Is there any way we can do this locally? I will probably install XAMPP or one of the variants of those packages. I don't assume cPanel can be included also locally? If not, I just want to know how I can use the database from my live forum in my own computer.
Thanks. |
Comment/Reply (w/o sign-up)
Houdini
Jan 19 2006, 04:11 PM
You just need to export your database using phpMyAdmin as a file (there is a check box that gives you the option to save your database as a file), and put the database which will be the name of your database followed by .sql. This may be quite a large file and if so may exceed the maximum time for execution, you will not know until you try. When you have XAMPP (one that I like and have used for three years) running start the phpMyAdmin there and depending of the version of phpMyAdmin you have either select SQL or Import and let it know that you are going to use a text file and then browse for the file you just downloaded from the host. One of two things will happen, it will either execute and reproduce the database for you along with the structure and data or it will produce an error complaining about the query exceeding the max execution time. If it gives an error then you will need to open the sql file with an editor like PHP Designer or HTML Kit or whatever and breack it up into smaller files and run the queries one at a time untill all have been executed.
Comment/Reply (w/o sign-up)
WeaponX
Jan 20 2006, 02:01 AM
I usually use the cPanel backup option and go to download the database there. Is that ok also? I will install XAMPP back on this machine and see if I can import that database via phpMyAdmin. Quick question (had this on my mind for a while). When I download the database backup, it seems to save it as a .gz zip file. I actually tried unzipping it before...Winzip asks what file extension to use - I think I might have typed sql or just left it. Well, either way, it seems I got it extracted to a file over 600MB in size!!! I opened that sucker up...  took a while. So is that the database itself or just a compressed one (the .gz file)? Thanks Houdini...
Comment/Reply (w/o sign-up)
Houdini
Jan 21 2006, 12:57 AM
That file size seems way too large, do this instead. Go to your cPanel and then select phpMyAdmin and then select the database you want to export as shown below look at the arrows included with text explainations.  Pay attention to the rest of the fields that are selected (they should be that way by default) except for the save as file and possibly the Compression: Your database should never expand to more than your webspace size (!%MB or 150MB) which is all your files plus the database. It will probably be more like maybe 13-40MB. If you use the technique as shown in the screenshot above you will notice that it will be an SQL file so it is usually the name of your database plus the extension of .sql. Like I said earlier when you import or run an sql query from a text file (an sql is a text file) sometimes it will throw an error about exceeding tthe max execution time. Try using the above and let me know what you get, and after running on your XAMPP if it does exceed your max execution time then you will need to break the sql into a few smaller files like sql1 sql2 sql3 and so on.
Comment/Reply (w/o sign-up)
WeaponX
Jan 21 2006, 09:27 PM
Do I need to select any of the tables listed on the upper left of the table there? I just left it and did the things you mentionend (only checkbox part was different). What was I downloading then (cPanel->Backups)? I saw my forum database there and have been downloading it from there for a while. I recall even doing a restore over a month ago (something bombed out on me and had to do it). It took a while restoring all the tables, but I got it up and working. I have 120 tables in the database  I see half that say backup_...in front of them. Can I safely remove these? Are these making the database backup file larger and does it slow down my forum by keeping them there? Should I worry about the overhead time section? Saw a bunch that don't have any overhead, but some tables do. Thanks Houdini.
Comment/Reply (w/o sign-up)
Houdini
Jan 21 2006, 11:58 PM
No, what you see will send the entire contents of the database in this case it is exporting the database xtra if you just wanted to export certain databases then you would make selectio(s), but in this case you would be exporting the whole shooting match (database xtra and all tables). Well you probably did download the database but subject to the other programs control, here using phpMyAdmin you have a certain amout of control over the process, especially if you want to control compression. As far as your backups theyshould have some sort of time or date associated with them, I would delete all but the most recent one. The file you get from phpMyAdmin will pretty much be about the same but I am not sure, before you delete any file though make sure that after you have your exported file and set it up on your local machine then you can delete them, you might want a backup if you want your local machine to have all the same more recent posts and members and all, but for testing you don't really need that. The overhead can be fixed after the database is installed and running then just optimize it and it will take care of the overhead. You should optimize your web sql server tables every so often, if you don't have that ability within your ACP then you can use phpMyAdmin.
Comment/Reply (w/o sign-up)
WeaponX
Jan 22 2006, 11:12 PM
OK, getting mixed results again...I did exactly as you mentioned and got a SQL file that's 126MB in size. Did I try opening it? Heck yeah But it gave me a message (using Metapad here...). QUOTE This file is not a valid text file. It may be a binary file. Convert all NULL terminators to spaces and ond load anyway? Yes or No yields the same result...a blank Metapad/notepad file  What's wrong here? At least for the Backups I downloaded via cPanel, I can extract and view that 600MB+ file QUOTE As far as your backups theyshould have some sort of time or date associated with them, I would delete all but the most recent one. Sorry..wasn't clear there. I meant the tables I see in phpMyAdmin. They have backup_ in front as the prefix. Can I remove those from the database? They look exactly the same as the other tables (duplicates with the prefix backup_ in front) in the current DB. Sorry for sounding "noobish", but what is ACP? cPanel? I have no idea how to optimize the tables. All I see in cPanel->Database are buttons for Delete, Check and Repair next to my forum database. More questions...what's the check and repair for and should I run them?
Comment/Reply (w/o sign-up)
Houdini
Jan 23 2006, 12:47 AM
OK I see what is going on (well kinda). When you made backups to your database it merely took all the tables and added a backup_ prefix and added them to your database, which means that effectively you doubled the size of your data base. Yes you can safely 'drop' those tables, and the sql file is in fact a text file but I have never heard of the editor you are using you might want to get HTML Kit or PHP Designer, both are free and under 5 meg combined and will certainly open a file like that. If you have a 125 megabyte databse that has been doubled by adding the backup_ prefix to all the real tables that are actually being used by your system then you really have a 67.5MEG database, which is still kinda bug. A file of that size using import would most likely exceed the 30 maximum execution time and would have to be broken down into probably 6 to 10MEG chucks, but you need an editor that understands an sql file. If when you get the sql file open with an editor that will open it use the search feature to find all instances of the backup_ and eliminate all files related to that condition. Then break the file up into several complete sql aueries, an sql dump will let ou know by just looking at it where a tables data begins and ends. When you have this much done then just go to your phpMyAdmin on your localhost and import each file in order like db1, db2, db3, db4...and so on. There is another alternative also, you could download just the structure of your database which will give you a rather small sql that when run will set up all the tables required by your program along with the structure of the tables. Then you can download the data sql for those tables and build back the entire database with all med=ssages, members, permissions, categories, and so on.
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : restore, database, backup, locally
- Free Or Opensource Database/schema Browser?
Alternatives to TOAD or PL/SQL Developer (6)
How To Understand A Database Schema
A very nice and simple tutorial (9) Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
Best Database
(16) What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?....
Some Useful Database Links.
(7) I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl....
Database Access On Remote Server W/jsp
(2) Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!....
Space Needed For Database
(10) Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Accessing Ms Access Database From A Centralized Location?
(10) Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
Mysql Backup With Another Address?
(4) I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
here at astahost, can I restore those backups? Is the change of the site address going to interfere
with this? Is there anyway I can edit those databases to work with my new address? Please help me
out here!....
Integrate Access Database Onto Intranet Site
Looking to integrate access database into my intranet site (5) Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d....
Database
prblem with it (1) i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose file
from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend....
Connecting To A Remote Database
(9) I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
- Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
the IP of server C. Though I am having trouble connecting from server C which is with a different
webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
only be used to connect a client - e.g. my pc to the remote server A. I do not ha....
Need Help In Database Auto_increment
(9) i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx....
My Sql Database Help?
(3) Ok, i am new at web design, i dont know too much about it... I was working on a website for about
a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
acquire the URL of the database or any information i dont know what it means at all.. i just want to
do a simple login feature, i mean this is my first website and i am learning so I think it would be
a great feature to add in and learn. i can create data bases from there but do n....
Database Size?
So how big is everybody's MySQL database? (10) Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
databases were? Do you have really big ones, or are they relatively small? Also what do you store in
them? (just text, or binary data as well)....
How Many Concurrent Users For Oracle Database?
This is to analyse and get perfect result for How many concurrent use (1) Hi friends, How many concurrent users can practically access the oracle database?
they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
number of concurrent users depend on any other factors as wel? I think depend on parameter
1.session 2.processes session Specific connection of a user to an Oracle instance through a user
process. A session lasts from the time the user connects until the time the user disconnects or
exits the database application. Multiple sessions can be created and exist concurrently for ....
Database Programming In Vba 6.0
(1) hi , i need some sample program in database.thanks....
Can't Import Backup Sql File To Localhost
(11) Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for
testing purposes. This has always worked for me in the past, but I'm having some problems with
it lately. I'm backing up my database via phpMyAdmin->Database->Export->Select All and
downloaded as a .gz file. I'm using Windows XP Home with WAMP installed, so it has MySQL built
in. It's version 5.0.27. I ran all the services and at the prompt typed in: mysql -u root -p
backup.sql > testDB My root account in WAMP has no password, so when it prompts for a ....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(6) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
MySQL Output Database Question
(19) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
MS-database To MySQL
I'd like to batch them (6) Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
control the output of the Windows-thing (so I can't export them to a *csv or something), I can
write an import script. But since I'm not that great with Regular Expressions and don't know
anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
out the field information and put it in arrays or something more readable. It wou....
The Best Database
What do you think is the best database? (48) Ive been planning to create a online application which requires tons of stuff from database. Ive
been using interbase, at first it was good but after a month i find it not user friendly at all...
Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?....
Mirror My MySQL Database To Another Mysql Server
(7) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Need Advice On Creating Online Music Database
ps - dont know anything about databases! (6) I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
Notice from microscopic^earthling:
Topic edited to reflect content....
MySQL Database Problems
(8) My friends have a little forum running here . The problem is that quite often we get the following
message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/vhosts/roh....
How Can I Import Csv Files To My MySQL Database?
I was able to export but where's import? (3) I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
can I import csv files in mysql server?....
Embedded Database
Embedded Data base at client side, (7) Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G....
phpBB Database Transfer
Anyone here knows how to? (10) Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
transfer the datas(users,configs, all of them) contained in my current forum to another one in
phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
in advance, hope anyone here knows how to.....
Looking for restore, database, backup, locally
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for restore, database, backup, locally
|
advertisement
|
|
