Dream.In.Code > Programming Help > Databases

Welcome to Dream.In.Code
	Become an Expert! Join 150,093 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,821 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

Sql - Phpmyadmin

Reply to this topic

Start new topic

Sql - Phpmyadmin, can you copy

iamcenz	2 Sep, 2002 - 12:56 AM Post #1
You wish you were my hand! Joined: 26 Mar, 2001 Posts: 2,385 Dream Kudos: 201 My Contributions	hey can you copy your whole data base into SQL so i can move it to somewhere else and still keep the whole structure. cause right now i am doing everything on my local machine with Foxserve 2.1. but soon i am going to need to move it to my server for the site. so is there a way i can do this with out losing the structure of the database, i dont care about the data, cause its all test crap.
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

iamcenz	RE: Sql - Phpmyadmin 2 Sep, 2002 - 09:57 AM Post #2
You wish you were my hand! Joined: 26 Mar, 2001 Posts: 2,385 Dream Kudos: 201 My Contributions	bump
	This Post Was Helpful!

skyhawk133	RE: Sql - Phpmyadmin 2 Sep, 2002 - 10:22 AM Post #3
Head DIC Head Joined: 17 Mar, 2001 Posts: 15,277 Thanked: 61 times Dream Kudos: 1650 Expert In: Web Development My Contributions	yes there is, gimme a bit and I'll get on my machine and show you... It's something like, export data or dump database or something... dump data... something like that, and there are radio buttons whether you wanna do the structure, structure and data, data, etc. etc.
	This Post Was Helpful!

iamcenz	RE: Sql - Phpmyadmin 2 Sep, 2002 - 10:43 AM Post #4
You wish you were my hand! Joined: 26 Mar, 2001 Posts: 2,385 Dream Kudos: 201 My Contributions	i thought dump data was deleting it.
	This Post Was Helpful!

Amadeus	RE: Sql - Phpmyadmin 3 Sep, 2002 - 11:43 AM Post #5
g++ -o drink whiskey.cpp Joined: 12 Jul, 2002 Posts: 12,355 Thanked: 51 times Dream Kudos: 25 My Contributions	QUOTE(skyhawk133 @ Sep 2 2002, 02:22 PM) yes there is, gimme a bit and I'll get on my machine and show you... It's something like, export data or dump database or something... dump data... something like that, and there are radio buttons whether you wanna do the structure, structure and data, data, etc. etc. There's usually an export utility, like you mentioned. From there, you'll be guided through what you want to export, where you want to export to, stuff like that.
	This Post Was Helpful!

MathewS	RE: Sql - Phpmyadmin 3 Sep, 2002 - 03:18 PM Post #6
D.I.C Regular Joined: 14 May, 2002 Posts: 252 Thanked: 1 times Dream Kudos: 1 My Contributions	What you want to do is. Open your browser and head over to your phpmyadmin Login to it. Select the database to the left. When the page on the right has loaded, go down to the bottom of the page. Select which table you want (Ctrl + Lclick to select multiple). Select if you want structure, data, or both from radio. Click "Add 'drop table' ", "Complete inserts ", "Extended inserts". You can select is you want the file in a zip file as well by selecting "Send" and which method you want. Hope that helps. Remember to click "Go" as well.
	This Post Was Helpful!

Resonance	RE: Sql - Phpmyadmin 9 Sep, 2002 - 08:54 PM Post #7
D.I.C Head Joined: 8 Feb, 2002 Posts: 95	Using the command "mysqldump" will generate a text file of sql commands that would generate your current database. Anyone know why the MySqlfront got discontinued?
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 1/9/09 12:09AM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Be Social

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month